explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 24eY

Settings
# exclusive inclusive rows x rows loops node
1. 5.179 129.118 ↓ 37.4 299 1

Hash Full Join (cost=2,468.98..2,778.36 rows=8 width=100) (actual time=114.272..129.118 rows=299 loops=1)

  • Hash Cond: (block_cte_1.bidx = block_cte.bidx)
  • Filter: ((block_cte.bidx IS NULL) OR (block_cte_1.bidx IS NULL) OR ((block_cte_1.block_chksum)::text <> (block_cte.block_chksum)::text))
  • Rows Removed by Filter: 6,394
2.          

CTE block_cte

3. 0.915 16.372 ↑ 1.0 13,635 1

Append (cost=0.00..1,436.84 rows=13,733 width=197) (actual time=0.046..16.372 rows=13,635 loops=1)

4. 10.477 10.477 ↑ 1.1 6,872 1

Seq Scan on block_seek_pos (cost=0.00..667.20 rows=7,399 width=197) (actual time=0.045..10.477 rows=6,872 loops=1)

  • Filter: ((sbid > 0) AND (schid <= 3) AND ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text))
  • Rows Removed by Filter: 7,082
5. 4.980 4.980 ↓ 1.1 6,763 1

Seq Scan on block_seek_pos block_seek_pos_1 (cost=0.00..632.31 rows=6,334 width=197) (actual time=2.112..4.980 rows=6,763 loops=1)

  • Filter: ((sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
  • Rows Removed by Filter: 7,191
6. 6.131 31.748 ↓ 836.5 6,692 1

Hash Join (cost=344.73..654.06 rows=8 width=50) (actual time=22.043..31.748 rows=6,692 loops=1)

  • Hash Cond: (block_cte_1.sbid = t1_1.sbid)
7. 5.912 5.912 ↓ 98.0 6,763 1

CTE Scan on block_cte block_cte_1 (cost=0.00..308.99 rows=69 width=50) (actual time=2.273..5.912 rows=6,763 loops=1)

  • Filter: ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text)
  • Rows Removed by Filter: 6,872
8. 1.868 19.705 ↓ 304.2 6,692 1

Hash (cost=344.46..344.46 rows=22 width=8) (actual time=19.705..19.705 rows=6,692 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 326kB
9. 0.944 17.837 ↓ 304.2 6,692 1

Subquery Scan on t1_1 (cost=343.85..344.46 rows=22 width=8) (actual time=11.311..17.837 rows=6,692 loops=1)

10. 4.805 16.893 ↓ 304.2 6,692 1

GroupAggregate (cost=343.85..344.24 rows=22 width=16) (actual time=11.308..16.893 rows=6,692 loops=1)

  • Group Key: block_cte_2.bidx
11. 4.210 12.088 ↓ 294.0 6,763 1

Sort (cost=343.85..343.90 rows=23 width=16) (actual time=11.292..12.088 rows=6,763 loops=1)

  • Sort Key: block_cte_2.bidx
  • Sort Method: quicksort Memory: 510kB
12. 7.878 7.878 ↓ 294.0 6,763 1

CTE Scan on block_cte block_cte_2 (cost=0.00..343.33 rows=23 width=16) (actual time=2.800..7.878 rows=6,763 loops=1)

  • Filter: ((sbid > 0) AND ((fguid)::text = '5303ee30dacdde734dec68ede9346d8f'::text))
  • Rows Removed by Filter: 6,872
13. 2.981 92.191 ↓ 2,230.7 6,692 1

Hash (cost=687.38..687.38 rows=3 width=50) (actual time=92.191..92.191 rows=6,692 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 594kB
14. 42.589 89.210 ↓ 2,230.7 6,692 1

Hash Join (cost=378.10..687.38 rows=3 width=50) (actual time=40.506..89.210 rows=6,692 loops=1)

  • Hash Cond: (block_cte.sbid = t1.sbid)
15. 6.184 6.184 ↓ 99.6 6,872 1

CTE Scan on block_cte (cost=0.00..308.99 rows=69 width=50) (actual time=0.052..6.184 rows=6,872 loops=1)

  • Filter: ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text)
  • Rows Removed by Filter: 6,763
16. 1.728 40.437 ↓ 836.5 6,692 1

Hash (cost=378.00..378.00 rows=8 width=8) (actual time=40.437..40.437 rows=6,692 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 326kB
17. 0.891 38.709 ↓ 836.5 6,692 1

Subquery Scan on t1 (cost=377.78..378.00 rows=8 width=8) (actual time=32.850..38.709 rows=6,692 loops=1)

18. 4.240 37.818 ↓ 836.5 6,692 1

GroupAggregate (cost=377.78..377.92 rows=8 width=16) (actual time=32.849..37.818 rows=6,692 loops=1)

  • Group Key: block_cte_3.bidx
19. 4.278 33.578 ↓ 859.0 6,872 1

Sort (cost=377.78..377.80 rows=8 width=16) (actual time=32.834..33.578 rows=6,872 loops=1)

  • Sort Key: block_cte_3.bidx
  • Sort Method: quicksort Memory: 515kB
20. 29.300 29.300 ↓ 859.0 6,872 1

CTE Scan on block_cte block_cte_3 (cost=0.00..377.66 rows=8 width=16) (actual time=0.002..29.300 rows=6,872 loops=1)

  • Filter: ((sbid > 0) AND (schid <= 3) AND ((fguid)::text = 'ac15c785776ab44bd58a60f99a240515'::text))
  • Rows Removed by Filter: 6,763
Planning time : 1.730 ms
Execution time : 131.491 ms