explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lxm

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 4.038 ↓ 42.0 42 1

Sort (cost=2,338.08..2,338.08 rows=1 width=323) (actual time=4.019..4.038 rows=42 loops=1)

  • Sort Key: homeaglow_job.start
  • Sort Method: quicksort Memory: 36kB
2. 0.124 3.948 ↓ 42.0 42 1

Nested Loop Anti Join (cost=1.35..2,338.07 rows=1 width=323) (actual time=0.140..3.948 rows=42 loops=1)

3. 0.290 2.504 ↓ 165.0 165 1

Nested Loop Left Join (cost=0.92..2,284.26 rows=1 width=323) (actual time=0.032..2.504 rows=165 loops=1)

  • Filter: (homeaglow_voucher.id IS NULL)
  • Rows Removed by Filter: 55
4. 1.334 1.334 ↓ 2.5 220 1

Index Scan using homeaglow_job_cb24373b on homeaglow_job (cost=0.50..1,552.88 rows=88 width=152) (actual time=0.023..1.334 rows=220 loops=1)

  • Index Cond: (customer_id = ANY ('{562568,167939,548953,565052,506807,549044,517670,505689,55483,566418,551980,388124,526477,558494,102062,546597,547218,338477,547080,208382,484584,549130,332513,561832,542732,146964,543565,195118,563156,555675,562882,158433,459618,552998,474687,537278,19277,552005,542257,532996,542504,535691,13091,329636,557650,548166,556420,533500,366561,468140,523810,211577,547280,546109,519227,548238,508635,554372,482398,284205,544243,554355}'::integer[]))
  • Filter: ((((customer_pay_via)::text <> 'cash'::text) OR (customer_pay_via IS NULL)) AND ((job_status)::text = 'invoiced'::text))
  • Rows Removed by Filter: 494
5. 0.880 0.880 ↓ 0.0 0 220

Index Scan using homeaglow_voucher_d697ea38 on homeaglow_voucher (cost=0.42..8.30 rows=1 width=171) (actual time=0.003..0.004 rows=0 loops=220)

  • Index Cond: (homeaglow_job.id = job_id)
6. 1.320 1.320 ↑ 33.0 1 165

Index Scan using homeaglow_customerpaymenttxn_d697ea38 on homeaglow_customerpaymenttxn u1 (cost=0.43..604.53 rows=33 width=4) (actual time=0.008..0.008 rows=1 loops=165)

  • Index Cond: (job_id = homeaglow_job.id)
  • Filter: success
  • Rows Removed by Filter: 3