explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dDAx

Settings
# exclusive inclusive rows x rows loops node
1. 2.831 1,856,973.733 ↑ 1.0 1 1

Limit (cost=17,936.51..17,936.52 rows=1 width=8) (actual time=1,856,973.727..1,856,973.733 rows=1 loops=1)

  • Buffers: shared hit=41897780
2. 46.627 1,856,970.902 ↑ 1.0 1 1

Aggregate (cost=17,936.51..17,936.52 rows=1 width=8) (actual time=1,856,970.902..1,856,970.902 rows=1 loops=1)

  • Buffers: shared hit=41897780
3. 964,706.021 1,856,924.275 ↓ 18,763.0 18,763 1

Nested Loop (cost=1,000.00..17,936.51 rows=1 width=0) (actual time=95.453..1,856,924.275 rows=18,763 loops=1)

  • Join Filter: (t.id = te.transaction_id)
  • Rows Removed by Join Filter: 4160714013
  • Buffers: shared hit=41897780
4. 322.810 469.153 ↓ 18,763.0 18,763 1

Gather (cost=1,000.00..10,714.09 rows=1 width=8) (actual time=0.748..469.153 rows=18,763 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1
5. 146.343 146.343 ↓ 6,254.0 6,254 3

Parallel Seq Scan on transactions t (cost=0.00..9,713.99 rows=1 width=8) (actual time=0.026..146.343 rows=6,254 loops=3)

  • Filter: ((chargeback_at IS NULL) AND (deleted_at IS NULL) AND (date >= '2019-04-01 00:00:00'::timestamp without time zone) AND (date <= '2019-04-30 23:59:59'::timestamp without time zone) AND (transaction_type_id = 1))
  • Rows Removed by Filter: 173037
  • Buffers: shared hit=5792
6. 891,749.101 891,749.101 ↑ 1.0 221,752 18,763

Seq Scan on transactions_erps te (cost=0.00..4,450.52 rows=221,752 width=4) (actual time=0.007..47.527 rows=221,752 loops=18,763)

  • Buffers: shared hit=41897779