explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SFqr

Settings
# exclusive inclusive rows x rows loops node
1. 108.813 721.651 ↑ 1.0 988 1

Aggregate (cost=254,113.6..254,133.5 rows=995 width=176) (actual time=720.553..721.651 rows=988 loops=1)

  • Buffers: shared hit=134397 read=12888
2. 23.361 612.838 ↓ 2.1 151,244 1

Nested Loop (cost=0.56..251,937.46 rows=72,538 width=64) (actual time=0.084..612.838 rows=151,244 loops=1)

  • Buffers: shared hit=134397 read=12888
3. 0.477 0.477 ↑ 1.0 1,000 1

Seq Scan on t_trans4process_t tt (cost=0..11.6 rows=1,000 width=81) (actual time=0.023..0.477 rows=1,000 loops=1)

  • Buffers: shared hit=16
4. 14.000 589.000 ↑ 9.4 151 1,000

Append (cost=0.56..237.8 rows=1,413 width=53) (actual time=0.032..0.589 rows=151 loops=1,000)

  • Buffers: shared hit=134381 read=12888
5. 570.000 570.000 ↑ 9.4 151 1,000

Index Scan using idx_fact_transactions_2019_04_04_agg on fact_transactions_2019_04_04 t (cost=0.56..229.49 rows=1,412 width=53) (actual time=0.031..0.57 rows=151 loops=1,000)

  • Index Cond: ((t.agg_hash)::text = (tt.agg_hash)::text)
  • Filter: ((t.trans_created >= '2019-04-04 00:00:00'::timestamp without time zone) AND (t.trans_created < '2019-04-05 00:00:00'::timestamp without time zone) AND (tt.trans_completed_day = t.trans_completed_day))
  • Buffers: shared hit=131381 read=12888
6. 5.000 5.000 ↓ 0.0 0 1,000

Index Scan using idx_fact_transactions_defaul_agg on fact_transactions_defaul t_1 (cost=0.27..1.24 rows=1 width=61) (actual time=0.005..0.005 rows=0 loops=1,000)

  • Index Cond: ((t_1.agg_hash)::text = (tt.agg_hash)::text)
  • Filter: ((t_1.trans_created >= '2019-04-04 00:00:00'::timestamp without time zone) AND (t_1.trans_created < '2019-04-05 00:00:00'::timestamp without time zone) AND (tt.trans_completed_day = t_1.trans_completed_day))
  • Buffers: shared hit=3000