explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qkAB

Settings
# exclusive inclusive rows x rows loops node
1. 0.129 6.145 ↑ 1.0 344 1

Unique (cost=4,826.68..4,829.26 rows=344 width=8) (actual time=5.955..6.145 rows=344 loops=1)

  • Buffers: shared hit=3775 read=1 dirtied=2
2. 0.193 6.016 ↑ 1.0 344 1

Sort (cost=4,826.68..4,827.54 rows=344 width=8) (actual time=5.954..6.016 rows=344 loops=1)

  • Sort Key: fa.facil_addr_id, faip.facil_addr_ins_plan_id
  • Sort Method: quicksort Memory: 41kB
  • Buffers: shared hit=3775 read=1 dirtied=2
3. 0.475 5.823 ↑ 1.0 344 1

Nested Loop (cost=1.28..4,812.18 rows=344 width=8) (actual time=3.212..5.823 rows=344 loops=1)

  • Buffers: shared hit=3775 read=1 dirtied=2
4. 0.279 4.660 ↑ 1.0 344 1

Nested Loop (cost=0.85..4,500.79 rows=344 width=8) (actual time=3.192..4.660 rows=344 loops=1)

  • Buffers: shared hit=2390 read=1 dirtied=1
5. 3.753 3.753 ↑ 1.0 314 1

Index Only Scan using facil_pkey on facil f (cost=0.42..1,889.92 rows=314 width=8) (actual time=3.180..3.753 rows=314 loops=1)

  • Index Cond: ((facil_id = ANY ('{1000907506,1000907510,1000907519,1000907521,1000907522,1000907524,1000907527,1000907552,1000907529,1000907532,1000907535,1000907537,1000907539,1000907540,1000907542,1000907545,1000907548,1000907549,1000907554,1000…
  • Heap Fetches: 314
  • Buffers: shared hit=1130 read=1
6. 0.628 0.628 ↑ 1.0 1 314

Index Scan using facil_addr_fkidx on facil_addr fa (cost=0.42..8.30 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=314)

  • Index Cond: ((facil_id = f.facil_id) AND (dw_id = 44))
  • Buffers: shared hit=1260 dirtied=1
7. 0.688 0.688 ↑ 1.0 1 344

Index Scan using facil_addr_ins_plan_fkidx on facil_addr_ins_plan faip (cost=0.43..0.90 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=344)

  • Index Cond: ((facil_addr_id = fa.facil_addr_id) AND (dw_id = 44))
  • Buffers: shared hit=1385 dirtied=1
Planning time : 3,494.657 ms
Execution time : 6.337 ms