explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ykdF : test

Settings
# exclusive inclusive rows x rows loops node
1. 138.934 3,741.362 ↑ 4.2 144,519 1

Unique (cost=229,707.92..237,295.21 rows=606,983 width=48) (actual time=3,458.470..3,741.362 rows=144,519 loops=1)

2. 412.089 3,602.428 ↑ 1.8 339,480 1

Sort (cost=229,707.92..231,225.38 rows=606,983 width=48) (actual time=3,458.469..3,602.428 rows=339,480 loops=1)

  • Sort Key: storekeeper_request.id, storekeeper_request.telephone, applicant_user.email, storekeeper_request.update_at
  • Sort Method: external merge Disk: 20944kB
3. 567.327 3,190.339 ↑ 1.8 339,480 1

Hash Join (cost=60,192.49..152,730.77 rows=606,983 width=48) (actual time=1,344.333..3,190.339 rows=339,480 loops=1)

  • Hash Cond: (storekeeper_request_requirement.storekeeper_request_id = storekeeper_request.id)
4. 1,279.386 1,279.386 ↑ 1.1 847,882 1

Seq Scan on storekeeper_request_requirement (cost=0.00..73,156.85 rows=894,025 width=4) (actual time=0.454..1,279.386 rows=847,882 loops=1)

  • Filter: (((review_status)::text <> 'REJECTED'::text) AND (requirement_id <> 1))
  • Rows Removed by Filter: 473223
5. 168.835 1,343.626 ↓ 1.0 339,836 1

Hash (cost=52,991.45..52,991.45 rows=338,243 width=48) (actual time=1,343.626..1,343.626 rows=339,836 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3908kB
6. 445.440 1,174.791 ↓ 1.0 339,836 1

Hash Join (cost=25,793.51..52,991.45 rows=338,243 width=48) (actual time=541.461..1,174.791 rows=339,836 loops=1)

  • Hash Cond: (applicant_user.id = storekeeper_request.applicant_user_id)
7. 190.273 190.273 ↓ 1.0 501,872 1

Seq Scan on applicant_user (cost=0.00..12,850.95 rows=496,995 width=29) (actual time=0.016..190.273 rows=501,872 loops=1)

8. 160.193 539.078 ↓ 1.0 339,836 1

Hash (cost=19,252.47..19,252.47 rows=338,243 width=27) (actual time=539.078..539.078 rows=339,836 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3009kB
9. 378.885 378.885 ↓ 1.0 339,836 1

Seq Scan on storekeeper_request (cost=0.00..19,252.47 rows=338,243 width=27) (actual time=0.466..378.885 rows=339,836 loops=1)

  • Filter: ((state)::text <> ALL ('{APPROVED,REJECTED}'::text[]))
  • Rows Removed by Filter: 162036