explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jc7C

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1,483.360 ↑ 1.0 1 1

Limit (cost=451.630..451.640 rows=1 width=255) (actual time=1,483.356..1,483.360 rows=1 loops=1)

2. 0.058 1,483.354 ↑ 1.0 1 1

Sort (cost=451.630..451.640 rows=1 width=255) (actual time=1,483.354..1,483.354 rows=1 loops=1)

  • Sort Key: quebec DESC
  • Sort Method: quicksort Memory: 25kB
3. 1,209.425 1,483.296 ↑ 1.0 1 1

Bitmap Heap Scan on kilo_xray (cost=5.410..451.620 rows=1 width=255) (actual time=1,473.097..1,483.296 rows=1 loops=1)

  • Recheck Cond: ((kilo_quebec = 48) AND (yankee five NULL))
  • Filter: (zulu = 'charlie_november'::bigint)
  • Rows Removed by Filter: 998309
  • Heap Blocks: exact=128768
4. 273.871 273.871 ↓ 8,836.5 998,520 1

Bitmap Index Scan on charlie_foxtrot (cost=0.000..5.410 rows=113 width=0) (actual time=273.871..273.871 rows=998,520 loops=1)

  • Index Cond: (kilo_quebec = 48)
Planning time : 1.333 ms
Execution time : 1,483.518 ms