explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yuL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=105,139.16..407,795.64 rows=1 width=40) (actual rows= loops=)

  • AND ((no_lt)::text !~~ '2%'::text) AND ((no_lt)::text !~~ '3%'::text) AND ((no_lt)::text !~~ '4%'::text) AND ((no_lt)::text !~~ '5%'::text) AND ((no_lt)::text !~~ '6%'::text) AND ((no_lt)::text !~~ '7%'::text) AND ((no_lt)::text !~~ '8%'::text) AND ((no_lt)::text !~~ '9%'::text))
  • ",988,955,956,965,966,973,974,982,975,976,977,978,979}'::text[])) AND ((code_produit)::text <> ALL ('{44,4Q,17,38,62,4D,35,4B,61,41,60,84,4C,33,4A,36,85,4X,3S,4G,4N,4O,37,4P,49,3T,9F,9D,52,34,29,21,25,50,9L,9J,9E,
  • 9K"}'::text[])))
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=105,138.74..407,794.78 rows=1 width=40) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=105,138.18..108,907.24 rows=376,906 width=14) (actual rows= loops=)

  • Group Key: e_1.no_lt
4. 0.000 0.000 ↓ 0.0

Index Only Scan using events_stat_trafic_idx on events e_1 (cost=0.57..104,096.51 rows=416,667 width=14) (actual rows= loops=)

  • Index Cond: ((code_evt = ANY ('{SC,PC,EC,PE}'::text[])) AND (date_evt > '2019-09-26 05:00:00'::timestamp without time zone) AND (date_evt <= '2019-09-27 05:00:00'::timestamp without time zone))
  • Filter: (((no_lt)::text !~~ '%KK'::text) AND ((no_lt)::text !~~ 'OQ%'::text) AND ((no_lt)::text !~~ '0%'::text) AND ((no_lt)::text !~~ '1%'::text)
5. 0.000 0.000 ↓ 0.0

Index Scan using parcels_pkey on parcels p (cost=0.56..0.78 rows=1 width=40) (actual rows= loops=)

  • Index Cond: ((parcel_id)::text = (e_1.no_lt)::text)
  • Filter: (((code_produit)::text <> 'IP2'::text) AND ((code_produit)::text <> '0H'::text) AND ((code_produit)::text <> '3'::text) AND ((code_produit)::text <> '40'::text) AND (date_premier_evt_transport_reel_lt_reconnue > '2019-09-23 00:00:00'::timestamp without time zone) AND ((code_service)::text <> ALL ('{514,514,947,948,949,950,951,952,959,960,961,962,963,964,969,970,971,972,983,984,"985
6. 0.000 0.000 ↓ 0.0

Index Only Scan using idx_lyn1e210_tlt_admin_admin_events_no_lt_tmp on lyn1e210_tlt_admin_admin_events_no_lt_tmp e (cost=0.43..0.65 rows=1 width=14) (actual rows= loops=)

  • Index Cond: (no_lt = (p.parcel_id)::text)