explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CkSb

Settings
# exclusive inclusive rows x rows loops node
1. 14.631 523.877 ↓ 19.0 17,081 1

Sort (cost=58,587.32..58,589.56 rows=898 width=64) (actual time=522.402..523.877 rows=17,081 loops=1)

  • Sort Key: evar.event_id, evar.event_variable_value_id
  • Sort Method: quicksort Memory: 3067kB
  • Total runtime: 524.838 ms
2. 13.482 509.246 ↓ 19.0 17,081 1

Nested Loop (cost=37.75..58,543.27 rows=898 width=64) (actual time=178.978..509.246 rows=17,081 loops=1)

3. 14.471 478.683 ↓ 19.0 17,081 1

Nested Loop (cost=37.75..58,291.75 rows=898 width=53) (actual time=178.970..478.683 rows=17,081 loops=1)

4. 9.969 326.308 ↓ 25.6 22,984 1

Nested Loop (cost=37.75..39,580.11 rows=898 width=47) (actual time=178.932..326.308 rows=22,984 loops=1)

5. 15.664 260.165 ↓ 31.1 28,087 1

Hash Join (cost=37.75..39,321.16 rows=904 width=51) (actual time=178.917..260.165 rows=28,087 loops=1)

  • Hash Cond: (evar.event_variable_name_id = evn.event_variable_name_id)
6. 6.759 244.161 ↓ 1.0 69,243 1

Append (cost=0.00..39,018.88 rows=68,130 width=36) (actual time=178.527..244.161 rows=69,243 loops=1)

7. 0.008 0.008 ↓ 0.0 0 1

Index Scan using evf_idx_msgutc on event_variable_fact evar (cost=0.00..8.31 rows=1 width=30) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((message_utc >= '2019-10-06 09:08:29+00'::timestamp with time zone) AND (message_utc <= '2019-10-08 15:08:29+00'::timestamp with time zone))
  • Filter: (eg_id = ANY ('{4020144,4020150,4020157,4020213,4020216,4020222,4020263,4020297,4020328,4020331,4020333,4020343,4020346,4020352,4020359,4020380,4020383,4020389,4020408,4020422,4020424,4020425,
8. 0.037 178.477 ↓ 0.0 0 1

Bitmap Heap Scan on event_variable_fact_p2019w40 evar (cost=7,201.65..8,241.92 rows=262 width=37) (actual time=178.477..178.477 rows=0 loops=1)

  • Recheck Cond: ((message_utc >= '2019-10-06 09:08:29+00'::timestamp with time zone) AND (message_utc <= '2019-10-08 15:08:29+00'::timestamp with time zone) AND (eg_id = ANY ('{4020144,4020150,4020157,4
9. 2.329 178.440 ↓ 0.0 0 1

BitmapAnd (cost=7,201.65..7,201.65 rows=262 width=0) (actual time=178.440..178.440 rows=0 loops=1)

10. 176.060 176.060 ↓ 91.4 1,411,830 1

Bitmap Index Scan on event_variable_fact_p2019w40_message_utc_aircraft_id_etd_id_idx (cost=0.00..627.68 rows=15,440 width=0) (actual time=176.060..176.060 rows=1,411,830 loops=1)

  • Index Cond: ((message_utc >= '2019-10-06 09:08:29+00'::timestamp with time zone) AND (message_utc <= '2019-10-08 15:08:29+00'::timestamp with time zone))
11. 0.051 0.051 ↓ 0.0 0 1

Bitmap Index Scan on event_variable_fact_p2019w40_eg_id_idx (cost=0.00..6,573.59 rows=281,431 width=0) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: (eg_id = ANY ('{4020144,4020150,4020157,4020213,4020216,4020222,4020263,4020297,4020328,4020331,4020333,4020343,4020346,4020352,4020359,4020380,4020383,4020389,4020408,4020422,
12. 58.917 58.917 ↓ 1.0 69,243 1

Index Scan using event_variable_fact_p2019w41_eg_id_idx on event_variable_fact_p2019w41 evar (cost=0.04..30,768.65 rows=67,867 width=36) (actual time=0.040..58.917 rows=69,243 loops=1)

  • Index Cond: (eg_id = ANY ('{4020144,4020150,4020157,4020213,4020216,4020222,4020263,4020297,4020328,4020331,4020333,4020343,4020346,4020352,4020359,4020380,4020383,4020389,4020408,4020422,4020424,4020
  • Filter: ((message_utc >= '2019-10-06 09:08:29+00'::timestamp with time zone) AND (message_utc <= '2019-10-08 15:08:29+00'::timestamp with time zone))
13. 0.006 0.340 ↑ 1.0 12 1

Hash (cost=37.60..37.60 rows=12 width=23) (actual time=0.340..0.340 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
14. 0.334 0.334 ↑ 1.0 12 1

Seq Scan on event_variable_name evn (cost=0.00..37.60 rows=12 width=23) (actual time=0.010..0.334 rows=12 loops=1)

  • Filter: ((evn_code)::text = ANY ('{latitude_decimal,longitude_decimal,flight_number,flight_number_iata,flight_number_icao,wind_dir_deg,wind_speed_kts,icing_status_code,heater_status_code,peak_edr,disp
  • Rows Removed by Filter: 892
15. 56.174 56.174 ↑ 1.0 1 28,087

Index Scan using pk_etd_id on event_type_dimension etd (cost=0.00..0.28 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=28,087)

  • Index Cond: (etd_id = evar.etd_id)
  • Filter: (((event_type_code)::text <> 'ARINC620-MTC'::text) AND ((event_type_code)::text <> 'ARINC620-MOC'::text))
  • Rows Removed by Filter: 0
16. 22.984 137.904 ↑ 3.0 1 22,984

Append (cost=0.00..20.81 rows=3 width=14) (actual time=0.006..0.006 rows=1 loops=22,984)

17. 22.984 22.984 ↓ 0.0 0 22,984

Index Scan using pk_qcgradef_id on qc_grade_fact qc (cost=0.00..10.83 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=22,984)

  • Index Cond: (event_variable_value_id = evar.event_variable_value_id)
  • Filter: ((message_utc >= '2019-10-06 09:08:29+00'::timestamp with time zone) AND (message_utc <= '2019-10-08 15:08:29+00'::timestamp with time zone))
18. 22.984 22.984 ↓ 0.0 0 22,984

Index Scan using qc_grade_fact_p2019w40_pkey on qc_grade_fact_p2019w40 qc (cost=0.00..7.86 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=22,984)

  • Index Cond: (event_variable_value_id = evar.event_variable_value_id)
  • Filter: ((message_utc >= '2019-10-06 09:08:29+00'::timestamp with time zone) AND (message_utc <= '2019-10-08 15:08:29+00'::timestamp with time zone))
19. 68.952 68.952 ↑ 1.0 1 22,984

Index Scan using qc_grade_fact_p2019w41_pkey on qc_grade_fact_p2019w41 qc (cost=0.00..2.12 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=22,984)

  • Index Cond: (event_variable_value_id = evar.event_variable_value_id)
  • Filter: ((message_utc >= '2019-10-06 09:08:29+00'::timestamp with time zone) AND (message_utc <= '2019-10-08 15:08:29+00'::timestamp with time zone))
20. 17.081 17.081 ↑ 1.0 1 17,081

Index Scan using pk_qc_grade_alg_id on qc_grade_algorithm_dimension qcg (cost=0.00..0.27 rows=1 width=19) (actual time=0.001..0.001 rows=1 loops=17,081)

  • Index Cond: (qc_grade_algorithm_id = qc.qc_grade_algorithm_id)