explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fqQL

Settings
# exclusive inclusive rows x rows loops node
1. 0.074 18,539.810 ↓ 50.0 100 1
→

Limit (cost=0.00..5.00 rows=2 width=46) (actual time=1,665.204..18,539.810 rows=100 loops=1)

2. 10,242.089 18,539.736 ↓ 50.0 100 1
→

Nested Loop (cost=0.00..5.00 rows=2 width=46) (actual time=1,665.202..18,539.736 rows=100 loops=1)

  • Join Filter: (customer.identifier = account.owning_customer_identifier)
  • Rows Removed by Join Filter: 260,786,321
3. 0.116 2.152 ↓ 123.5 247 1
→

Append (cost=0.00..2.40 rows=2 width=12) (actual time=0.077..2.152 rows=247 loops=1)

4. 0.004 0.004 ↓ 0.0 0 1
→

Seq Scan on customer (cost=0.00..0.00 rows=1 width=12) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: ((cutoff_date = '2019-11-29'::date) AND ((category = ANY ('{31,32,33,34,35,36,37,38,40,41,42,43}'::text[])) OR (category IS NULL)))
5. 2.032 2.032 ↓ 247.0 247 1
→

Index Scan using data_customer_2019_11_cutoff_date_identifier_key on data_customer_2019_11 (cost=0.57..2.40 rows=1 width=12) (actual time=0.072..2.032 rows=247 loops=1)

  • Index Cond: (cutoff_date = '2019-11-29'::date)
  • Filter: ((category = ANY ('{31,32,33,34,35,36,37,38,40,41,42,43}'::text[])) OR (category IS NULL))
  • Rows Removed by Filter: 91
6. 6,901.847 8,295.495 ↓ 527,907.5 1,055,815 247
→

Materialize (cost=0.00..2.53 rows=2 width=46) (actual time=2.701..33.585 rows=1,055,815 loops=247)

7. 40.525 1,393.648 ↓ 529,764.0 1,059,528 1
→

Append (cost=0.00..2.52 rows=2 width=46) (actual time=667.180..1,393.648 rows=1,059,528 loops=1)

8. 0.002 0.002 ↓ 0.0 0 1
→

Seq Scan on account (cost=0.00..0.00 rows=1 width=60) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((account_type = ANY ('{C1,C2}'::t_account_type[])) AND (cutoff_date = '2019-11-29'::date) AND (is_debit_installment_possible = 1))
9. 1,353.121 1,353.121 ↓ 1,059,528.0 1,059,528 1
→

Index Scan using data_account_2019_11_cutoff_date_idx on data_account_2019_11 (cost=0.57..2.52 rows=1 width=32) (actual time=667.177..1,353.121 rows=1,059,528 loops=1)

  • Index Cond: (cutoff_date = '2019-11-29'::date)
  • Filter: ((account_type = ANY ('{C1,C2}'::t_account_type[])) AND (is_debit_installment_possible = 1))
  • Rows Removed by Filter: 6,449,272
Planning time : 35.012 ms
Execution time : 18,553.259 ms