explain.depesz.com

PostgreSQL's explain analyze made readable

Result: snCe

Settings
# exclusive inclusive rows x rows loops node
1. 0.220 446.971 ↑ 1.0 1 1

Aggregate (cost=101,659.43..101,659.44 rows=1 width=32) (actual time=446.970..446.971 rows=1 loops=1)

2. 0.000 446.751 ↓ 0.0 0 1

Nested Loop Left Join (cost=93,633.78..101,659.41 rows=1 width=16) (actual time=446.751..446.751 rows=0 loops=1)

3. 24.039 461.796 ↓ 0.0 0 1

Gather (cost=93,633.49..101,658.78 rows=1 width=24) (actual time=446.750..461.796 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 40.369 437.757 ↓ 0.0 0 3

Nested Loop (cost=92,633.49..100,658.68 rows=1 width=24) (actual time=437.757..437.757 rows=0 loops=3)

5. 4.280 397.348 ↑ 1.1 957 3

Parallel Bitmap Heap Scan on screening_applicant_result_values sarv (cost=92,631.38..97,481.69 rows=1,009 width=24) (actual time=393.945..397.348 rows=957 loops=3)

  • Recheck Cond: ((created_on >= '2019-09-27 22:59:59-06'::timestamp with time zone) AND (created_on <= '2019-10-25 22:59:59-06'::timestamp with time zone))
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 674
  • Heap Blocks: exact=848
6. 1.962 1.962 ↓ 1.0 4,893 1

Bitmap Index Scan on idx_screening_applicant_result_values_created_on (cost=0.00..83.86 rows=4,843 width=0) (actual time=1.961..1.962 rows=4,893 loops=1)

  • Index Cond: ((created_on >= '2019-09-27 22:59:59-06'::timestamp with time zone) AND (created_on <= '2019-10-25 22:59:59-06'::timestamp with time zone))
7.          

SubPlan (for Parallel Bitmap Heap Scan)

8. 78.227 391.106 ↑ 52.8 1,050 3

HashAggregate (cost=91,854.23..92,408.38 rows=55,415 width=4) (actual time=390.245..391.106 rows=1,050 loops=3)

  • Group Key: screening_applicant_result_values.screening_transaction_id
9. 312.879 312.879 ↑ 1.0 146,882 3

Index Scan using idx_screening_applicant_result_values_created_on on screening_applicant_result_values (cost=0.42..91,486.78 rows=146,983 width=4) (actual time=0.102..312.879 rows=146,882 loops=3)

  • Index Cond: ((created_on > '2019-08-30 22:59:59-06'::timestamp with time zone) AND (created_on < '2019-09-27 22:59:59-06'::timestamp with time zone))
10. 0.023 0.040 ↓ 0.0 0 2,870

Bitmap Heap Scan on screening_transaction_transmissions stt (cost=2.11..3.14 rows=1 width=16) (actual time=0.040..0.040 rows=0 loops=2,870)

  • Recheck Cond: ((screening_applicant_id = sarv.screening_applicant_id) AND (screening_id = sarv.screening_id))
  • Filter: ((status_type_id = 2) AND (sarv.cid = cid) AND (sarv.screening_transaction_id = screening_transaction_id) AND (screening_data_provider_id = ANY ('{9,23,35,38,87}'::integer[])))
  • Rows Removed by Filter: 9
  • Heap Blocks: exact=12052
11. 0.002 0.017 ↓ 0.0 0 2,870

BitmapAnd (cost=2.11..2.11 rows=1 width=0) (actual time=0.017..0.017 rows=0 loops=2,870)

12. 0.008 0.008 ↓ 1.8 9 2,870

Bitmap Index Scan on idx_screening_transaction_transmissions_screening_applicant_id (cost=0.00..0.92 rows=5 width=0) (actual time=0.008..0.008 rows=9 loops=2,870)

  • Index Cond: (screening_applicant_id = sarv.screening_applicant_id)
13. 0.007 0.007 ↓ 2.0 14 2,682

Bitmap Index Scan on idx_screening_transaction_transmissions_screening_id (cost=0.00..0.94 rows=7 width=0) (actual time=0.007..0.007 rows=14 loops=2,682)

  • Index Cond: (screening_id = sarv.screening_id)
14. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_screening_applicant_credit_alerts_screening_applicant_id on screening_applicant_credit_alerts saca (cost=0.29..0.62 rows=1 width=16) (never executed)

  • Index Cond: (screening_applicant_id = sarv.screening_applicant_id)
  • Filter: ((alert_code IS NOT NULL) AND (alert_type_id = ANY ('{12,13}'::integer[])) AND (cid = sarv.cid) AND (screening_id = sarv.screening_id) AND (screening_transaction_id = sarv.screening_transaction_id))
Planning time : 105.094 ms