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. 5.686 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)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=3522, temp read=990 written=4447
4. 0.874 3,098.524 ↑ 2,957.2 93 2 / 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. 1,305.441 3,097.650 ↑ 1,113.4 247 2 / 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. 929.901 1,792.209 ↓ 1.1 292,503 2 / 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. 386.476 859.138 ↑ 1.2 71,989 2 / 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. 178.345 178.345 ↑ 1.2 71,987 2 / 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. 148.814 294.317 ↑ 1.2 54,676 2 / 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. 145.503 145.503 ↑ 1.2 54,676 2 / 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. 1.469 3.170 ↓ 1.3 577 2 / 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. 1.656 1.701 ↓ 1.3 577 2 / 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)))
  • Heap Blocks: exact=9
  • Buffers: shared hit=46
13. 0.045 0.045 ↑ 1.0 748 2 / 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
Planning time : 0.779 ms
Execution time : 3,107.875 ms