explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EIAl

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 110.302 ↑ 1.0 1 1

GroupAggregate (cost=1.11..12,438.03 rows=1 width=44) (actual time=110.300..110.302 rows=1 loops=1)

  • Group Key: party_0.id
2. 0.002 110.293 ↑ 1.0 1 1

Nested Loop (cost=1.11..12,438.01 rows=1 width=36) (actual time=34.965..110.293 rows=1 loops=1)

3. 0.007 110.276 ↑ 1.0 1 1

Nested Loop (cost=0.83..12,429.71 rows=1 width=35) (actual time=34.950..110.276 rows=1 loops=1)

  • Join Filter: ((virtual_3.site_id)::text = (site_3.id)::text)
4. 0.031 110.237 ↑ 56.0 1 1

Nested Loop (cost=0.42..12,394.92 rows=56 width=36) (actual time=34.915..110.237 rows=1 loops=1)

5. 110.152 110.152 ↑ 849.0 1 1

Seq Scan on plc_part part_3 (cost=0.00..6,152.87 rows=849 width=70) (actual time=34.832..110.152 rows=1 loops=1)

  • Filter: (upper((serial_number)::text) ~~ '15168PP81550412'::text)
  • Rows Removed by Filter: 169857
6. 0.054 0.054 ↑ 1.0 1 1

Index Scan using asset_track_virtual_event_terminal_id_idx on asset_track_virtual_event virtual_3 (cost=0.42..7.34 rows=1 width=106) (actual time=0.053..0.054 rows=1 loops=1)

  • Index Cond: ((terminal_id)::text = (part_3.terminal_id)::text)
  • Filter: ((inventory_event_id IS NULL) AND (estate_owner_id = 358))
7. 0.006 0.032 ↑ 8.0 1 1

Materialize (cost=0.41..28.09 rows=8 width=71) (actual time=0.031..0.032 rows=1 loops=1)

8. 0.026 0.026 ↑ 8.0 1 1

Index Scan using plc_site_party_id_idx on plc_site site_3 (cost=0.41..28.05 rows=8 width=71) (actual time=0.024..0.026 rows=1 loops=1)

  • Index Cond: ((party_id)::text = '-6cd1dec3:15ec8ab382a:-7b6b:AC150046'::text)
  • Filter: ((site_type)::text = 'SITE_ADDRESS'::text)
  • Rows Removed by Filter: 1
9. 0.015 0.015 ↑ 1.0 1 1

Index Scan using plc_party_pkey on plc_party party_0 (cost=0.28..8.30 rows=1 width=36) (actual time=0.013..0.015 rows=1 loops=1)

  • Index Cond: ((id)::text = '-6cd1dec3:15ec8ab382a:-7b6b:AC150046'::text)
  • Filter: (estate_owner_id = 358)
Planning time : 1.708 ms
Execution time : 110.422 ms