explain.depesz.com

PostgreSQL's explain analyze made readable

Result: huYT

Settings
# exclusive inclusive rows x rows loops node
1. 15,106.013 203,895.089 ↑ 4,722.1 11,524 1

Nested Loop (cost=1.01..927,952.23 rows=54,418,000 width=257) (actual time=1.970..203,895.089 rows=11,524 loops=1)

2. 169,401.126 169,401.126 ↑ 1.4 111,425 1

Index Scan using postings_v2_createdat_idx on postings_v2 lp (cost=0.57..221,079.74 rows=152,934 width=1,050) (actual time=0.050..169,401.126 rows=111,425 loops=1)

  • Index Cond: (createdat >= '2019-01-10 00:00:00'::timestamp without time zone)
  • Filter: (((attrjson ->> 'super-card.mid'::text) IS NOT NULL) AND (recordtype = 'DEBIT'::record_type))
  • Rows Removed by Filter: 862903
3. 19,387.950 19,387.950 ↓ 0.0 0 111,425

Index Scan using ledger_master_pkey on ledger_master lm (cost=0.44..2.56 rows=1 width=831) (actual time=0.169..0.174 rows=0 loops=111,425)

  • Index Cond: (ledgerid = lp.ledgerid)
  • Filter: (((producttype)::text = ANY ('{MCC_VOUCHER_RECIPIENT,CASH}'::text[])) AND (ifi = 156699))
  • Rows Removed by Filter: 1