explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r4cT5

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 0.133 ↑ 28.5 2 1

Hash Join (cost=4.59..7.28 rows=57 width=0) (actual time=0.105..0.133 rows=2 loops=1)

  • Hash Cond: ((ticket_totals.stop_id = tickets_crosstab.stop_id) AND (ticket_totals.client_day = tickets_crosstab.client_day))
2. 0.035 0.035 ↑ 1.0 95 1

Seq Scan on ticket_totals (cost=0.00..1.95 rows=95 width=20) (actual time=0.005..0.035 rows=95 loops=1)

3. 0.006 0.069 ↓ 2.0 18 1

Hash (cost=4.45..4.45 rows=9 width=20) (actual time=0.069..0.069 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
4. 0.020 0.063 ↓ 2.0 18 1

HashAggregate (cost=4.36..4.45 rows=9 width=20) (actual time=0.058..0.063 rows=18 loops=1)

  • Group Key: tickets_crosstab.stop_id, tickets_crosstab.client_day
5. 0.043 0.043 ↑ 1.0 19 1

Seq Scan on tickets_crosstab (cost=0.00..4.27 rows=19 width=20) (actual time=0.004..0.043 rows=19 loops=1)

  • Filter: deleted
  • Rows Removed by Filter: 108
Planning time : 0.181 ms