explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LC2H

Settings
# exclusive inclusive rows x rows loops node
1. 44.101 291.991 ↓ 305.1 78,422 1

Gather (cost=1,000.42..32,560.24 rows=257 width=2,365) (actual time=3.119..291.991 rows=78,422 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 25.697 247.890 ↓ 244.3 26,141 3

Parallel Append (cost=0.42..31,534.54 rows=107 width=2,365) (actual time=0.064..247.890 rows=26,141 loops=3)

3. 222.193 222.193 ↓ 244.3 26,141 3

Parallel Index Scan using idx_provider_id_dec_26_2018 on fact_transaction_header_dec_26_2018 ft (cost=0.42..31,534.01 rows=107 width=2,365) (actual time=0.058..222.193 rows=26,141 loops=3)

  • Index Cond: (payer_provider_id = 101)
  • Filter: ((payer_first_name IS NOT NULL) AND (payee_first_name IS NOT NULL) AND (transfer_date >= '2018-12-26 00:00:00'::timestamp without time zone) AND (transfer_date < '2018-12-27 00:00:00'::timestamp without time zone) AND ((payer_status I (...)
  • Rows Removed by Filter: 47843
Planning time : 15.749 ms
Execution time : 326.055 ms