explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dOUw

Settings
# exclusive inclusive rows x rows loops node
1. 0.201 0.464 ↑ 14.1 9 1

Hash Join (cost=14.56..32.50 rows=127 width=0) (actual time=0.151..0.464 rows=9 loops=1)

  • Hash Cond: ((ticket_totals.stop_id = tickets_crosstab.stop_id) AND (ticket_totals.client_day = tickets_crosstab.client_day))
2. 0.169 0.169 ↓ 1.0 682 1

Seq Scan on ticket_totals (cost=0.00..12.80 rows=680 width=20) (actual time=0.005..0.169 rows=682 loops=1)

3. 0.006 0.094 ↓ 2.8 17 1

Hash (cost=14.47..14.47 rows=6 width=20) (actual time=0.094..0.094 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
4. 0.030 0.088 ↓ 2.8 17 1

HashAggregate (cost=14.41..14.47 rows=6 width=20) (actual time=0.082..0.088 rows=17 loops=1)

  • Group Key: tickets_crosstab.stop_id, tickets_crosstab.client_day
5. 0.058 0.058 ↑ 1.0 53 1

Index Scan using idx_tickets_crosstab_deleted on tickets_crosstab (cost=0.28..14.14 rows=53 width=20) (actual time=0.019..0.058 rows=53 loops=1)

  • Index Cond: (deleted = true)
  • Filter: deleted
Planning time : 0.468 ms