explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9XrM

Settings
# exclusive inclusive rows x rows loops node
1. 282.739 45,407.203 ↑ 1.0 1 1

Aggregate (cost=3,708,426.50..3,708,426.51 rows=1 width=96) (actual time=45,407.203..45,407.203 rows=1 loops=1)

  • Buffers: shared hit=235,057 read=1,201,788, temp read=221,592 written=221,592
2. 26,069.802 45,124.464 ↑ 1.0 1,035,379 1

Hash Join (cost=1,835,357.24..3,700,408.58 rows=1,069,055 width=17) (actual time=6,325.480..45,124.464 rows=1,035,379 loops=1)

  • Hash Cond: (ratedtrans1_.id = ratedtrans0_.id)
  • Buffers: shared hit=235,057 read=1,201,788, temp read=221,592 written=221,592
3. 12,734.106 12,734.106 ↑ 1.0 63,388,715 1

Seq Scan on billing_rated_transaction_status_open ratedtrans1_ (cost=0.00..1,196,121.95 rows=63,388,716 width=8) (actual time=0.021..12,734.106 rows=63,388,715 loops=1)

  • Filter: ((status)::text = 'OPEN'::text)
  • Buffers: shared read=403,763
4. 479.096 6,320.556 ↑ 1.0 1,035,379 1

Hash (cost=1,814,686.05..1,814,686.05 rows=1,069,055 width=25) (actual time=6,320.555..6,320.556 rows=1,035,379 loops=1)

  • Buckets: 16,384 Batches: 128 Memory Usage: 623kB
  • Buffers: shared hit=235,054 read=798,025, temp written=6,432
5. 5,841.460 5,841.460 ↑ 1.0 1,035,379 1

Index Scan using rt_ba_sub_index on billing_rated_transaction ratedtrans0_ (cost=0.56..1,814,686.05 rows=1,069,055 width=25) (actual time=0.077..5,841.460 rows=1,035,379 loops=1)

  • Index Cond: (billing_account__id = 57)
  • Filter: (usage_date < now())
  • Buffers: shared hit=235,054 read=798,025
Planning time : 1.288 ms
Execution time : 45,407.371 ms