explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6McR : Invoice Tasks - Declined Invoices

Settings
# exclusive inclusive rows x rows loops node
1. 1.078 120.104 ↑ 4.3 167 1

HashAggregate (cost=27,508.72..27,515.82 rows=710 width=112) (actual time=120.073..120.104 rows=167 loops=1)

  • Group Key: ecgps_core_study.id, ecgps_core_study.study_name, ecgps_core_study.protocol, ecgps_core_study.slug
2. 0.908 119.026 ↓ 1.3 1,124 1

Hash Join (cost=6,185.04..27,498 rows=858 width=112) (actual time=26.848..119.026 rows=1,124 loops=1)

3. 2.847 115.421 ↑ 1.0 1,124 1

Hash Join (cost=4,433.1..25,733.17 rows=1,176 width=66) (actual time=24.091..115.421 rows=1,124 loops=1)

4. 88.563 88.563 ↑ 1.0 1,124 1

Seq Scan on ecgps_core_invoice ecgps_core_invoice (cost=0..21,273.61 rows=1,176 width=66) (actual time=0.051..88.563 rows=1,124 loops=1)

  • Filter: ((invoice_status)::text = 'declined'::text)
5. 9.739 24.011 ↑ 1.0 30,982 1

Hash (cost=4,045.82..4,045.82 rows=30,982 width=66) (actual time=24.011..24.011 rows=30,982 loops=1)

6. 14.272 14.272 ↑ 1.0 30,982 1

Seq Scan on ecgps_core_payeeevent ecgps_core_payeeevent (cost=0..4,045.82 rows=30,982 width=66) (actual time=0.002..14.272 rows=30,982 loops=1)

7. 0.279 2.697 ↓ 1.4 710 1

Hash (cost=1,745.47..1,745.47 rows=518 width=145) (actual time=2.697..2.697 rows=710 loops=1)

8. 0.297 2.418 ↓ 1.4 710 1

Hash Join (cost=176.86..1,745.47 rows=518 width=145) (actual time=1.522..2.418 rows=710 loops=1)

9. 0.323 1.686 ↓ 1.4 710 1

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

10. 0.327 0.518 ↓ 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.224..0.518 rows=710 loops=1)

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

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

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

Hash (cost=88.1..88.1 rows=710 width=112) (actual time=0.845..0.845 rows=710 loops=1)

13. 0.426 0.426 ↑ 1.0 710 1

Seq Scan on ecgps_core_study ecgps_core_study (cost=0..88.1 rows=710 width=112) (actual time=0.002..0.426 rows=710 loops=1)

14. 0.233 0.435 ↑ 1.0 718 1

Hash (cost=49.18..49.18 rows=718 width=33) (actual time=0.435..0.435 rows=718 loops=1)

15. 0.202 0.202 ↑ 1.0 718 1

Seq Scan on ecgps_core_event ecgps_core_event (cost=0..49.18 rows=718 width=33) (actual time=0.003..0.202 rows=718 loops=1)

Planning time : 2.027 ms
Execution time : 120.215 ms