explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EBn

Settings
# exclusive inclusive rows x rows loops node
1. 259.461 6,184.136 ↑ 5.8 1,384,878 1

Nested Loop (cost=438,231.57..1,287,452.53 rows=7,976,597 width=108) (actual time=665.229..6,184.136 rows=1,384,878 loops=1)

2. 6.325 674.515 ↑ 3.8 232 1

Unique (cost=438,231.00..438,235.59 rows=891 width=7) (actual time=660.939..674.515 rows=232 loops=1)

3. 449.803 668.190 ↓ 95.5 87,721 1

Sort (cost=438,231.00..438,233.30 rows=919 width=7) (actual time=660.938..668.190 rows=87,721 loops=1)

  • Sort Key: "FLIGHT_DATA_2019_04_19_COPY_1"."ICAO
  • Sort Method: external sort Disk: 1,464kB
4. 32.069 218.387 ↓ 95.5 87,721 1

Gather (cost=5,727.66..438,185.77 rows=919 width=7) (actual time=75.666..218.387 rows=87,721 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 164.966 186.318 ↓ 76.3 29,240 3 / 3

Parallel Bitmap Heap Scan on "FLIGHT_DATA_2019_04_19_COPY" "FLIGHT_DATA_2019_04_19_COPY_1" (cost=4,727.66..437,093.87 rows=383 width=7) (actual time=60.559..186.318 rows=29,240 loops=3)

  • Recheck Cond: ('0103000020E6100000010000000500000000000000000008400000000000804A400000000000000840000000000000494000000000000000C0000000000000494000000000000000C00000000000804A4000000000000008400000000000804A40'::geometry ~ geom)
  • Filter: ((("ACID")::text ~~ 'BAW%'::text) AND _st_contains('0103000020E6100000010000000500000000000000000008400000000000804A400000000000000840000000000000494000000000000000C0000000000000494000000000000000C00000000000804A4000000000 (...)
  • Rows Removed by Filter: 161,869
  • Heap Blocks: exact=3,243
6. 21.352 21.352 ↓ 4.4 573,328 1 / 3

Bitmap Index Scan on flight_data_2019_04_19_copy_geom_idx2 (cost=0.00..4,727.43 rows=130,535 width=0) (actual time=64.055..64.055 rows=573,328 loops=1)

  • Index Cond: ('0103000020E6100000010000000500000000000000000008400000000000804A400000000000000840000000000000494000000000000000C0000000000000494000000000000000C00000000000804A4000000000000008400000000000804A40'::geometry ~ ge (...)
7. 5,250.160 5,250.160 ↑ 1.5 5,969 232

Index Scan using flight_data_2019_04_19_copy_icao_idx on "FLIGHT_DATA_2019_04_19_COPY" (cost=0.57..863.58 rows=8,952 width=108) (actual time=0.490..22.630 rows=5,969 loops=232)

  • Index Cond: (("ICAO")::text = ("FLIGHT_DATA_2019_04_19_COPY_1"."ICAO")::text)
Planning time : 0.338 ms
Execution time : 6,239.097 ms