explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EZZZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.256 0.565 ↓ 32.0 32 1

Result (cost=0.29..86.41 rows=1 width=2,364) (actual time=0.163..0.565 rows=32 loops=1)

2. 0.013 0.309 ↓ 32.0 32 1

Append (cost=0.29..86.28 rows=1 width=1,854) (actual time=0.147..0.309 rows=32 loops=1)

3. 0.296 0.296 ↓ 32.0 32 1

Index Scan using idx_servicetype_jun_2016 on fact_transaction_header_jun_2016 ft (cost=0.29..86.28 rows=1 width=1,854) (actual time=0.146..0.296 rows=32 loops=1)

  • Index Cond: ((servicetype)::text = 'MERCHPAY'::text)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND (transfer_date >= '2016-06-01 00:00:00'::timestamp without time zone) AND (transfer_date < '2016-06-30 00:00:00'::timestamp without time zone) AND ((payer_status I (...)
  • Rows Removed by Filter: 26