explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZRpI

Settings
# exclusive inclusive rows x rows loops node
1. 1.293 280.888 ↓ 0.0 1 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=280.885..280.888 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 279.595 ↑ 1.0 1 1

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

3. 81.914 279.583 ↑ 1.0 10 1

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

  • Hash Cond: (tbl_visual_zone.id = rtpezoav_119075.zo_id)
4. 197.584 197.584 ↑ 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.083..197.584 rows=808,402 loops=1)

5. 0.008 0.085 ↑ 1.0 10 1

Hash (cost=33.15..33.15 rows=10 width=4) (actual time=0.084..0.085 rows=10 loops=1)

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

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

7. 0.073 0.073 ↑ 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.032..0.073 rows=10 loops=1)

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