explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HrTw

Settings
# exclusive inclusive rows x rows loops node
1. 147.442 310.195 ↓ 4.3 23,201 1

Hash Join (cost=853.71..2,174.02 rows=5,431 width=115) (actual time=154.865..310.195 rows=23,201 loops=1)

  • Hash Cond: (prod.prod_id = prod_prc.prod_id)
2. 7.940 7.940 ↓ 1.0 25,384 1

Seq Scan on prod (cost=0.00..1,170.82 rows=25,382 width=20) (actual time=0.006..7.940 rows=25,384 loops=1)

3. 43.052 154.813 ↓ 4.3 23,201 1

Hash (cost=785.82..785.82 rows=5,431 width=95) (actual time=154.813..154.813 rows=23,201 loops=1)

  • Buckets: 32768 (originally 8192) Batches: 1 (originally 1) Memory Usage: 2607kB
4. 64.736 111.761 ↓ 4.3 23,201 1

Hash Join (cost=9.68..785.82 rows=5,431 width=95) (actual time=0.186..111.761 rows=23,201 loops=1)

  • Hash Cond: (prod_prc.st_id = gnl_st.gnl_st_id)
5. 46.854 46.854 ↓ 1.0 23,481 1

Seq Scan on prod_prc (cost=0.00..633.79 rows=23,479 width=102) (actual time=0.003..46.854 rows=23,481 loops=1)

6. 0.029 0.171 ↑ 1.0 65 1

Hash (cost=8.86..8.86 rows=65 width=5) (actual time=0.171..0.171 rows=65 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
7. 0.142 0.142 ↑ 1.0 65 1

Seq Scan on gnl_st (cost=0.00..8.86 rows=65 width=5) (actual time=0.013..0.142 rows=65 loops=1)

  • Filter: ((shrt_code)::text = ANY ('{PNDG_ACTV,ACTV,PNDG_CNCL}'::text[]))
  • Rows Removed by Filter: 216