explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SiTL

Settings
# exclusive inclusive rows x rows loops node
1. 223.761 1,266.927 ↓ 3,041.2 1,176,937 1

Nested Loop (cost=438,231.57..446,148.18 rows=387 width=108) (actual time=691.959..1,266.927 rows=1,176,937 loops=1)

2. 8.876 707.646 ↑ 1.3 699 1

Unique (cost=438,231.00..438,237.89 rows=919 width=14) (actual time=691.912..707.646 rows=699 loops=1)

3. 474.136 698.770 ↓ 95.5 87,721 1

Sort (cost=438,231.00..438,233.30 rows=919 width=14) (actual time=691.911..698.770 rows=87,721 loops=1)

  • Sort Key: "FLIGHT_DATA_2019_04_19_COPY_1"."ICAO", "FLIGHT_DATA_2019_04_19_COPY_1"."ACID
  • Sort Method: external sort Disk: 2,088kB
4. 36.059 224.634 ↓ 95.5 87,721 1

Gather (cost=5,727.66..438,185.77 rows=919 width=14) (actual time=71.968..224.634 rows=87,721 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 168.199 188.575 ↓ 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=14) (actual time=50.418..188.575 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,919
6. 20.376 20.376 ↓ 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=61.128..61.128 rows=573,328 loops=1)

  • Index Cond: ('0103000020E6100000010000000500000000000000000008400000000000804A400000000000000840000000000000494000000000000000C0000000000000494000000000000000C00000000000804A4000000000000008400000000000804A40'::geometry ~ ge (...)
7. 335.520 335.520 ↓ 1,684.0 1,684 699

Index Scan using icao_acid_idx on "FLIGHT_DATA_2019_04_19_COPY" (cost=0.57..8.59 rows=1 width=108) (actual time=0.020..0.480 rows=1,684 loops=699)

  • Index Cond: ((("ICAO")::text = ("FLIGHT_DATA_2019_04_19_COPY_1"."ICAO")::text) AND (("ACID")::text = ("FLIGHT_DATA_2019_04_19_COPY_1"."ACID")::text))
Planning time : 0.417 ms
Execution time : 1,315.056 ms