explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bam7

Settings
# exclusive inclusive rows x rows loops node
1. 63.679 297.582 ↓ 1.0 61,568 1

Hash Join (cost=8,921.26..21,947.16 rows=61,368 width=117) (actual time=108.510..297.582 rows=61,568 loops=1)

2. 53.747 172.115 ↓ 1.0 61,568 1

Hash Join (cost=3,695.32..12,949.29 rows=61,368 width=87) (actual time=46.664..172.115 rows=61,568 loops=1)

  • Hash Cond: ((pcimiddle.product_id_)::text = (ypr.product_id_)::text)
3. 18.053 72.181 ↓ 1.0 61,568 1

Hash Join (cost=16.63..6,676.65 rows=61,368 width=40) (actual time=0.416..72.181 rows=61,568 loops=1)

  • Hash Cond: ((pcimiddle.product_category_id_)::text = (pcsmiddle.product_category_id_)::text)
4. 53.908 53.908 ↓ 1.0 61,568 1

Seq Scan on product_category_info pcimiddle (cost=0.00..5,816.21 rows=61,368 width=63) (actual time=0.176..53.908 rows=61,568 loops=1)

  • Filter: ((product_category_type_id_)::text = 'PARTMIDDLEGROUP'::text)
  • Rows Removed by Filter: 64929
5. 0.116 0.220 ↓ 1.1 357 1

Hash (cost=12.39..12.39 rows=339 width=35) (actual time=0.220..0.220 rows=357 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
6. 0.104 0.104 ↓ 1.1 357 1

Seq Scan on product_category_setting pcsmiddle (cost=0.00..12.39 rows=339 width=35) (actual time=0.011..0.104 rows=357 loops=1)

7. 19.851 46.187 ↓ 1.0 63,674 1

Hash (cost=2,323.31..2,323.31 rows=63,631 width=47) (actual time=46.187..46.187 rows=63,674 loops=1)

  • Buckets: 8192 Batches: 2 Memory Usage: 2502kB
8. 26.336 26.336 ↓ 1.0 63,674 1

Seq Scan on yimm_product_info ypr (cost=0.00..2,323.31 rows=63,631 width=47) (actual time=0.009..26.336 rows=63,674 loops=1)

9. 27.218 61.788 ↑ 1.0 65,108 1

Hash (cost=3,394.08..3,394.08 rows=65,108 width=104) (actual time=61.788..61.788 rows=65,108 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 2221kB
10. 34.570 34.570 ↑ 1.0 65,108 1

Seq Scan on product pr (cost=0.00..3,394.08 rows=65,108 width=104) (actual time=0.024..34.570 rows=65,108 loops=1)

Planning time : 2.629 ms
Execution time : 301.058 ms