explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FcDV : Payment Tasks - Declined Payments

Settings
# exclusive inclusive rows x rows loops node
1. 27.239 193.407 ↑ 11.0 435 1

HashAggregate (cost=111,480.96..111,528.95 rows=4,799 width=112) (actual time=193.337..193.407 rows=435 loops=1)

  • Group Key: ecgps_core_payment.study_id, ecgps_core_study.study_name, ecgps_core_study.protocol, ecgps_core_study.slug
2. 17.938 166.168 ↓ 1.3 41,835 1

Hash Join (cost=2,643.52..111,077.84 rows=32,250 width=112) (actual time=20.805..166.168 rows=41,835 loops=1)

3. 21.853 145.673 ↓ 1.3 41,835 1

Hash Join (cost=956.85..109,034.95 rows=32,250 width=66) (actual time=18.235..145.673 rows=41,835 loops=1)

  • Filter: (((ecgps_core_paymentcreationtype.short_name)::text = 'standard'::text) OR (ecgps_core_payment.payment_creation_type_id IS NULL))
4. 113.548 123.810 ↓ 1.0 41,929 1

Bitmap Heap Scan on ecgps_core_payment ecgps_core_payment (cost=955.81..108,655.38 rows=41,210 width=99) (actual time=18.198..123.81 rows=41,929 loops=1)

  • Heap Blocks: exact=29,071
5. 10.262 10.262 ↓ 1.0 41,929 1

Bitmap Index Scan on idx_payment_status_isautoapprove (cost=0..945.5 rows=41,210 width=0) (actual time=10.262..10.262 rows=41,929 loops=1)

  • Index Cond: ((status)::text = 'declined'::text)
6. 0.003 0.010 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=356) (actual time=0.01..0.01 rows=2 loops=1)

7. 0.007 0.007 ↑ 1.0 2 1

Seq Scan on ecgps_core_paymentcreationtype ecgps_core_paymentcreationtype (cost=0..1.02 rows=2 width=356) (actual time=0.007..0.007 rows=2 loops=1)

8. 0.256 2.557 ↓ 1.4 710 1

Hash (cost=1,680.19..1,680.19 rows=518 width=112) (actual time=2.557..2.557 rows=710 loops=1)

9. 0.359 2.301 ↓ 1.4 710 1

Hash Join (cost=118.7..1,680.19 rows=518 width=112) (actual time=0.941..2.301 rows=710 loops=1)

10. 1.045 1.224 ↓ 1.4 710 1

Bitmap Heap Scan on ecgps_core_userprofilestudy u0 (cost=21.73..1,576.09 rows=518 width=33) (actual time=0.213..1.224 rows=710 loops=1)

  • Heap Blocks: exact=233
11. 0.179 0.179 ↓ 1.4 710 1

Bitmap Index Scan on idx_userprofilestudy_profileid_sponsorportalaccess (cost=0..21.6 rows=518 width=0) (actual time=0.179..0.179 rows=710 loops=1)

  • Index Cond: (((profile_id)::text = '3ef4d33492f3489985aaba7eeb5e3918'::text) AND ((sponsor_portal_access)::text = 'active'::text))
12. 0.246 0.718 ↑ 1.0 710 1

Hash (cost=88.1..88.1 rows=710 width=79) (actual time=0.718..0.718 rows=710 loops=1)

13. 0.472 0.472 ↑ 1.0 710 1

Seq Scan on ecgps_core_study ecgps_core_study (cost=0..88.1 rows=710 width=79) (actual time=0.005..0.472 rows=710 loops=1)

Planning time : 1.812 ms
Execution time : 193.53 ms