explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Oy6p

Settings
# exclusive inclusive rows x rows loops node
1. 1.349 280.065 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=280.062..280.065 rows=1 loops=1)

  • Task Count: 1
  • Tuple data received from nodes: 2 bytes
  • Tasks Shown: All
  • -> Task
  • Tuple data received from node: 2 bytes
  • Node: host=localhost port=50,001 dbname=projects
2. 0.012 278.716 ↑ 1.0 1 1

Aggregate (cost=159,759.88..159,759.89 rows=1 width=8) (actual time=278.714..278.716 rows=1 loops=1)

3. 81.547 278.704 ↑ 1.0 10 1

Hash Semi Join (cost=33.28..159,759.86 rows=10 width=0) (actual time=24.645..278.704 rows=10 loops=1)

  • Hash Cond: (tbl_visual_zone.id = rtpezoav_119075.zo_id)
4. 197.018 197.018 ↑ 1.0 808,402 1

Seq Scan on tbl_visual_zone_119270 tbl_visual_zone (cost=0.00..157,598.30 rows=810,730 width=4) (actual time=0.013..197.018 rows=808,402 loops=1)

5. 0.008 0.139 ↑ 1.0 10 1

Hash (cost=33.15..33.15 rows=10 width=4) (actual time=0.138..0.139 rows=10 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.004 0.131 ↑ 1.0 10 1

Limit (cost=0.42..33.05 rows=10 width=4) (actual time=0.036..0.131 rows=10 loops=1)

7. 0.127 0.127 ↑ 58.4 10 1

Index Only Scan using rtpezoav_unique_119075 on rtpezoav_119075 (cost=0.42..1,906.19 rows=584 width=4) (actual time=0.034..0.127 rows=10 loops=1)

  • Index Cond: ((pe_id = 66) AND (ad_id = 50))
  • Heap Fetches: 10
Planning time : 0.382 ms
Execution time : 280.088 ms