explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NKhl : x

Settings
# exclusive inclusive rows x rows loops node
1. 4.337 3,105.233 ↑ 1.0 100 1

Limit (cost=47,628.17..47,636.99 rows=100 width=56) (actual time=3,099.702..3,105.233 rows=100 loops=1)

  • Buffers: shared hit=3522, temp read=990 written=4447
2. 0.000 3,100.896 ↑ 4,675.4 100 1

Group (cost=47,628.17..88,881.32 rows=467,535 width=56) (actual time=3,099.696..3,100.896 rows=100 loops=1)

  • Buffers: shared hit=1740, temp read=495 written=2228
3. 0.000 3,104.210 ↑ 2,750.2 100 1

Gather Merge (cost=47,628.17..84,068.45 rows=275,021 width=56) (actual time=3,099.691..3,104.21 rows=100 loops=1)

  • Buffers: shared hit=3522, temp read=990 written=4447
4. 1.748 6,197.048 ↑ 2,957.2 93 2

Group (cost=46,628.16..52,128.58 rows=275,021 width=56) (actual time=3,096.901..3,098.524 rows=93 loops=2)

  • Buffers: shared hit=3522, temp read=990 written=4447
5. 2,610.882 6,195.300 ↑ 1,113.4 247 2

Sort (cost=46,628.16..47,315.71 rows=275,021 width=56) (actual time=3,096.894..3,097.65 rows=247 loops=2)

  • Sort Key: price_1_1.brand, price_1_1.article, price_1_1.number, price_1_1.brand_print, price_1_1.article_print, price_1_1.price, price_6_10.price
  • Sort Method: external merge Disk: 17744kB
  • Buffers: shared hit=3522, temp read=990 written=4447
6. 1,859.802 3,584.418 ↓ 1.1 292,503 2

Hash Join (cost=3,123.47..12,380.14 rows=275,021 width=56) (actual time=297.814..1,792.209 rows=292,503 loops=2)

  • Buffers: shared hit=3507
7. 772.952 1,718.276 ↑ 1.2 71,989 2

Hash Join (cost=2,985.1..6,527.36 rows=84,691 width=56) (actual time=294.619..859.138 rows=71,989 loops=2)

  • Buffers: shared hit=3434
8. 356.690 356.690 ↑ 1.2 71,987 2

Seq Scan on price_1_1 price_1_1 (cost=0..2,903.91 rows=84,691 width=50) (actual time=0.009..178.345 rows=71,987 loops=2)

  • Buffers: shared hit=2057
9. 297.628 588.634 ↑ 1.2 54,676 2

Hash (cost=2,020.24..2,020.24 rows=64,324 width=20) (actual time=294.315..294.317 rows=54,676 loops=2)

  • Buffers: shared hit=1377
10. 291.006 291.006 ↑ 1.2 54,676 2

Seq Scan on price_6_10 price_6_10 (cost=0..2,020.24 rows=64,324 width=20) (actual time=0.011..145.503 rows=54,676 loops=2)

  • Buffers: shared hit=1377
11. 2.938 6.340 ↓ 1.3 577 2

Hash (cost=132.71..132.71 rows=453 width=6) (actual time=3.167..3.17 rows=577 loops=2)

  • Buffers: shared hit=46
12. 3.312 3.402 ↓ 1.3 577 2

Bitmap Heap Scan on report_brand_reference cr (cost=50..132.71 rows=453 width=6) (actual time=0.062..1.701 rows=577 loops=2)

  • Filter: ((cr.id > 0) AND ((cr.price_id = 10) OR (cr.price_id = 19) OR (cr.price_id = 8) OR (cr.price_id = 7) OR (cr.price_id = 11) OR (cr.price_id = 18) OR (cr.price_id = 12) OR (cr.price_id = 20) OR (cr.price_id = 13) OR (cr.price_id = 35) OR (cr.price_id = 15) OR (cr.price_id = 28) OR (cr.price_id = 16) OR (cr.price_id = 23) OR (cr.price_id = 32) OR (cr.price_id = 29) OR (cr.price_id = 25) OR (cr.price_id = 26) OR (cr.price_id = 36) OR (cr.price_id = 27) OR (cr.price_id = 31) OR (cr.price_id = 38) OR (cr.price_id = 2) OR (cr.price_id = 39) OR (cr.price_id = 40) OR (cr.price_id = 34) OR (cr.price_id = 41)))
  • Buffers: shared hit=46
13. 0.090 0.090 ↑ 1.0 748 2

Bitmap Index Scan on report_brand_reference_uindex (cost=0..49.89 rows=748 width=0) (actual time=0.043..0.045 rows=748 loops=2)

  • Index Cond: (cr.report_id = 1)
  • Buffers: shared hit=28