explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5MJY

Settings
# exclusive inclusive rows x rows loops node
1. 2,617.119 7,702.857 ↓ 265.4 5,266,989 1

WindowAgg (cost=2,050.16..2,496.67 rows=19,845 width=73) (actual time=4,244.006..7,702.857 rows=5,266,989 loops=1)

2. 4,479.404 5,085.738 ↓ 265.4 5,266,989 1

Sort (cost=2,050.16..2,099.77 rows=19,845 width=41) (actual time=4,243.993..5,085.738 rows=5,266,989 loops=1)

  • Sort Key: ic.br2_id, ca.zo_id, ca.attraction DESC
  • Sort Method: quicksort Memory: 608092kB
3. 576.738 606.334 ↓ 265.4 5,266,989 1

Hash Join (cost=267.62..633.57 rows=19,845 width=41) (actual time=25.963..606.334 rows=5,266,989 loops=1)

  • Hash Cond: (ca.br_id = ic.br_id)
4. 27.584 27.584 ↓ 83.6 83,603 1

Function Scan on getattractions ca (cost=0.25..10.25 rows=1,000 width=32) (actual time=23.943..27.584 rows=83,603 loops=1)

5. 0.407 2.012 ↑ 1.0 3,969 1

Hash (cost=217.76..217.76 rows=3,969 width=13) (actual time=2.012..2.012 rows=3,969 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 207kB
6. 1.605 1.605 ↑ 1.0 3,969 1

Seq Scan on rtsepebrbrav ic (cost=0.00..217.76 rows=3,969 width=13) (actual time=0.007..1.605 rows=3,969 loops=1)

  • Filter: ((value_num > '0'::numeric) AND (se_id = 1) AND (pe_id = 3) AND (ad_id = 66))
  • Rows Removed by Filter: 3969