- Plan:
Node Type: "Bitmap Heap Scan"
Parallel Aware: false
Relation Name: "z"
Alias: "z"
Startup Cost: 12.90
Total Cost: 24.27
Plan Rows: 3
Plan Width: 4
Actual Startup Time: 0.007
Actual Total Time: 0.009
Actual Rows: 3
Actual Loops: 1
Recheck Cond: "(id = ANY ('{1,1000,5000}'::integer[]))"
Rows Removed by Index Recheck: 0
Exact Heap Blocks: 3
Lossy Heap Blocks: 0
Shared Hit Blocks: 9
Shared Read Blocks: 0
Shared Dirtied Blocks: 0
Shared Written Blocks: 0
Local Hit Blocks: 0
Local Read Blocks: 0
Local Dirtied Blocks: 0
Local Written Blocks: 0
Temp Read Blocks: 0
Temp Written Blocks: 0
Plans:
- Node Type: "Bitmap Index Scan"
Parent Relationship: "Outer"
Parallel Aware: false
Index Name: "z_pkey"
Startup Cost: 0.00
Total Cost: 12.90
Plan Rows: 3
Plan Width: 0
Actual Startup Time: 0.006
Actual Total Time: 0.006
Actual Rows: 3
Actual Loops: 1
Index Cond: "(id = ANY ('{1,1000,5000}'::integer[]))"
Shared Hit Blocks: 6
Shared Read Blocks: 0
Shared Dirtied Blocks: 0
Shared Written Blocks: 0
Local Hit Blocks: 0
Local Read Blocks: 0
Local Dirtied Blocks: 0
Local Written Blocks: 0
Temp Read Blocks: 0
Temp Written Blocks: 0
Planning Time: 0.032
Triggers:
Execution Time: 0.017