explain.depesz.com

PostgreSQL's explain analyze made readable

Result: clSm

Settings
# exclusive inclusive rows x rows loops node
1. 0.217 8.834 ↑ 14.1 9 1

Hash Join (cost=158.15..176.09 rows=127 width=0) (actual time=8.051..8.834 rows=9 loops=1)

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

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

3. 0.009 7.458 ↓ 2.8 17 1

Hash (cost=158.06..158.06 rows=6 width=20) (actual time=7.458..7.458 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
4. 0.038 7.449 ↓ 2.8 17 1

HashAggregate (cost=158.00..158.06 rows=6 width=20) (actual time=7.446..7.449 rows=17 loops=1)

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

Seq Scan on tickets_crosstab (cost=0.00..157.73 rows=53 width=20) (actual time=1.282..7.411 rows=53 loops=1)

  • Filter: deleted
  • Rows Removed by Filter: 5620
Planning time : 9.881 ms