explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QV3j

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 411.024 ↓ 366.5 78,422 1

Gather Merge (cost=32,538.17..32,563.14 rows=214 width=2,365) (actual time=299.523..411.024 rows=78,422 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 191.187 924.255 ↓ 244.3 26,141 3

Sort (cost=31,538.15..31,538.42 rows=107 width=2,365) (actual time=289.049..308.085 rows=26,141 loops=3)

  • Sort Key: ft.transfer_date
  • Sort Method: external merge Disk: 8672kB
  • Worker 0: Sort Method: external merge Disk: 6464kB
  • Worker 1: Sort Method: external merge Disk: 6392kB
3. 75.363 733.068 ↓ 244.3 26,141 3

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

4. 657.705 657.705 ↓ 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.061..219.235 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_st (...)
  • Rows Removed by Filter: 47843