explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NiRm : Sharing 2

Settings
# exclusive inclusive rows x rows loops node
1. 41.421 1,455.744 ↑ 10.4 435 1

HashAggregate (cost=285,671.94..285,717.2 rows=4,526 width=112) (actual time=1,455.658..1,455.744 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. 22.447 1,414.323 ↓ 1.4 41,835 1

Hash Join (cost=2,134.78..285,296.45 rows=30,039 width=112) (actual time=3.116..1,414.323 rows=41,835 loops=1)

  • Filter: (((ecgps_core_paymentcreationtype.short_name)::text = 'standard'::text) OR (ecgps_core_payment.payment_creation_type_id IS NULL))
3. 41.601 1,391.872 ↓ 1.1 41,929 1

Hash Join (cost=2,133.74..284,938.12 rows=38,548 width=145) (actual time=3.103..1,391.872 rows=41,929 loops=1)

4. 1,347.338 1,347.338 ↓ 1.1 41,929 1

Seq Scan on ecgps_core_payment ecgps_core_payment (cost=0..282,393.25 rows=38,548 width=99) (actual time=0.16..1,347.338 rows=41,929 loops=1)

  • Filter: ((status)::text = 'declined'::text)
5. 0.259 2.933 ↓ 1.4 710 1

Hash (cost=2,127.6..2,127.6 rows=491 width=112) (actual time=2.933..2.933 rows=710 loops=1)

6. 0.444 2.674 ↓ 1.4 710 1

Hash Join (cost=126.82..2,127.6 rows=491 width=112) (actual time=1.061..2.674 rows=710 loops=1)

7. 1.213 1.332 ↓ 1.4 710 1

Bitmap Heap Scan on ecgps_core_userprofilestudy u0 (cost=29.85..2,023.87 rows=491 width=33) (actual time=0.155..1.332 rows=710 loops=1)

  • Filter: ((sponsor_portal_access)::text = 'active'::text)
  • Heap Blocks: exact=233
8. 0.119 0.119 ↓ 1.0 710 1

Bitmap Index Scan on ecgps_core_userprofilestudy_profile_id_like (cost=0..29.72 rows=707 width=0) (actual time=0.119..0.119 rows=710 loops=1)

  • Index Cond: ((profile_id)::text = '3ef4d33492f3489985aaba7eeb5e3918'::text)
9. 0.375 0.898 ↑ 1.0 710 1

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

10. 0.523 0.523 ↑ 1.0 710 1

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

11. 0.000 0.004 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=42) (actual time=0.004..0.004 rows=2 loops=1)

12. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on ecgps_core_paymentcreationtype ecgps_core_paymentcreationtype (cost=0..1.02 rows=2 width=42) (actual time=0.003..0.004 rows=2 loops=1)

Planning time : 1.841 ms
Execution time : 1,455.855 ms