explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XAO2

Settings
# exclusive inclusive rows x rows loops node
1. 173.068 15,793.768 ↓ 1.6 8 1

Gather (cost=1,000.86..268,184.89 rows=5 width=1,012) (actual time=10,158.305..15,793.768 rows=8 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.019 15,620.700 ↓ 1.5 3 3 / 3

Nested Loop Left Join (cost=0.86..267,184.39 rows=2 width=1,012) (actual time=10,546.131..15,620.700 rows=3 loops=3)

3. 15,618.798 15,618.798 ↓ 1.5 3 3 / 3

Parallel Index Scan using idx_scheduled_charges_lease_term_id on scheduled_charges sc (cost=0.43..267,179.39 rows=2 width=1,008) (actual time=10,544.491..15,618.798 rows=3 loops=3)

  • Index Cond: (cid = 5,222)
  • Filter: ((deleted_by IS NULL) AND (quote_id = ANY ('{421009,420518}'::integer[])) AND (ar_trigger_id = ANY ('{202,206,102,101,103,104,105,108,307}'::integer[])))
  • Rows Removed by Filter: 164,628
4. 1.883 1.883 ↓ 0.0 0 8 / 3

Index Scan using uk_quote_lease_term_lease_start_window_id on quote_lease_terms qlt (cost=0.43..2.47 rows=1 width=16) (actual time=0.705..0.706 rows=0 loops=8)

  • Index Cond: ((cid = sc.cid) AND (cid = 5,222) AND (quote_id = sc.quote_id) AND (lease_term_id = sc.lease_term_id))
Planning time : 6.108 ms
Execution time : 15,793.896 ms