explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aefl

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1.889 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.24..21.00 rows=1 width=138) (actual time=1.883..1.889 rows=1 loops=1)

  • Buffers: shared hit=37 read=2
  • I/O Timings: read=1.366
2. 0.007 0.007 ↑ 1.0 1 1

Index Scan using pk_changed_listing_json on changed_listing_json c (cost=0.42..2.64 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (changed_listing_json_id = 458,900)
  • Buffers: shared hit=4
3. 0.314 1.879 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.82..18.35 rows=1 width=114) (actual time=1.874..1.879 rows=1 loops=1)

  • Buffers: shared hit=33 read=2
  • I/O Timings: read=1.366
4. 0.003 1.533 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.38..15.75 rows=1 width=708) (actual time=1.529..1.533 rows=1 loops=1)

  • Buffers: shared hit=25 read=2
  • I/O Timings: read=1.366
5. 0.003 1.486 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.83..11.60 rows=1 width=672) (actual time=1.483..1.486 rows=1 loops=1)

  • Buffers: shared hit=20 read=2
  • I/O Timings: read=1.366
6. 0.003 1.469 ↑ 1.0 1 1

Nested Loop (cost=1.40..8.94 rows=1 width=691) (actual time=1.467..1.469 rows=1 loops=1)

  • Buffers: shared hit=16 read=2
  • I/O Timings: read=1.366
7. 0.004 1.462 ↑ 1.0 1 1

Nested Loop (cost=1.26..7.64 rows=1 width=691) (actual time=1.460..1.462 rows=1 loops=1)

  • Buffers: shared hit=14 read=2
  • I/O Timings: read=1.366
8. 0.004 0.628 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.97..5.63 rows=1 width=649) (actual time=0.626..0.628 rows=1 loops=1)

  • Buffers: shared hit=12 read=1
  • I/O Timings: read=0.544
9. 0.018 0.018 ↑ 1.0 1 1

Index Scan using listing_json_pkey on listing_json lj (cost=0.42..2.64 rows=1 width=605) (actual time=0.018..0.018 rows=1 loops=1)

  • Index Cond: (listing_json_id = c.listing_json_id)
  • Buffers: shared hit=7
10. 0.025 0.606 ↑ 1.0 1 1

Nested Loop (cost=0.55..2.98 rows=1 width=48) (actual time=0.605..0.606 rows=1 loops=1)

  • Buffers: shared hit=5 read=1
  • I/O Timings: read=0.544
11. 0.577 0.577 ↑ 1.0 1 1

Index Scan using agentcentre_agent_pkey on agent a (cost=0.42..2.15 rows=1 width=152) (actual time=0.576..0.577 rows=1 loops=1)

  • Index Cond: (agent_id = lj.agent_id)
  • Buffers: shared hit=3 read=1
  • I/O Timings: read=0.544
12. 0.004 0.004 ↑ 1.0 1 1

Index Scan using agent_status_pkey on agent_status s_1 (cost=0.13..0.70 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (agent_status_id = a.agent_status_id)
  • Buffers: shared hit=2
13. 0.830 0.830 ↑ 1.0 1 1

Index Scan using listing_pkey on listing l (cost=0.29..2.02 rows=1 width=46) (actual time=0.830..0.830 rows=1 loops=1)

  • Index Cond: (listing_id = lj.listing_id)
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.823
14. 0.004 0.004 ↑ 1.0 1 1

Index Scan using supplier_pkey on supplier s (cost=0.14..1.26 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (supplier_id = l.supplier_id)
  • Buffers: shared hit=2
15. 0.014 0.014 ↑ 1.0 1 1

Index Scan using idx_staging_datastore_listing_raw_key on listing sdl (cost=0.43..2.65 rows=1 width=24) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: ((portalsupplierid = s.legacy_supplier_id) AND (agentid = l.xml_agent_id) AND (uniqueid = l.unique_id))
  • Buffers: shared hit=4
16. 0.031 0.044 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..4.14 rows=1 width=44) (actual time=0.043..0.044 rows=1 loops=1)

  • Buffers: shared hit=5
17. 0.003 0.012 ↑ 1.0 1 1

Nested Loop (cost=0.42..2.85 rows=1 width=350) (actual time=0.011..0.012 rows=1 loops=1)

  • Buffers: shared hit=5
18. 0.005 0.005 ↑ 1.0 1 1

Index Scan using agency_pkey on agency a_1 (cost=0.29..2.01 rows=1 width=346) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (agency_id = a.agency_id)
  • Buffers: shared hit=3
19. 0.004 0.004 ↑ 1.0 1 1

Index Scan using agency_status_pkey on agency_status s_2 (cost=0.13..0.70 rows=1 width=12) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (agency_status_id = a_1.agency_status_id)
  • Buffers: shared hit=2
20. 0.001 0.001 ↓ 0.0 0 1

Index Scan using franchise_pkey on franchise f (cost=0.14..0.71 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (franchise_id = a_1.franchise_id)
21. 0.032 0.032 ↑ 1.0 1 1

Index Scan using pk_address on address a_2 (cost=0.43..2.53 rows=1 width=40) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: (oth_property_id = l.oth_property_id)
  • Buffers: shared hit=4