explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i8nx

Settings
# exclusive inclusive rows x rows loops node
1. 0.495 178.825 ↓ 298.0 298 1

Nested Loop (cost=1,002.56..52,815.54 rows=1 width=89) (actual time=4.331..178.825 rows=298 loops=1)

2. 0.280 177.734 ↓ 298.0 298 1

Nested Loop (cost=1,002.28..52,811.23 rows=1 width=81) (actual time=4.314..177.734 rows=298 loops=1)

3. 10.364 176.560 ↓ 298.0 298 1

Nested Loop (cost=1,001.85..52,802.77 rows=1 width=73) (actual time=4.286..176.560 rows=298 loops=1)

  • Join Filter: ((asmt.subtestid = tst.subtestid) AND ((x.objectivecode)::text = (obj.objectivecode)::text))
  • Rows Removed by Join Filter: 64070
4. 0.000 112.258 ↓ 298.0 298 1

Gather (cost=1,000.55..52,789.77 rows=1 width=74) (actual time=4.241..112.258 rows=298 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 0.045 147.277 ↓ 99.0 99 3 / 3

Nested Loop (cost=0.56..51,789.67 rows=1 width=74) (actual time=111.331..147.277 rows=99 loops=3)

6. 147.093 147.093 ↑ 2.0 1 3 / 3

Parallel Seq Scan on dim_assessmentparticipant asmt (cost=0.00..51,772.49 rows=2 width=52) (actual time=111.318..147.093 rows=1 loops=3)

  • Filter: ((administrationid = 593317) AND (participantid = 13843))
  • Rows Removed by Filter: 534393
7. 0.139 0.139 ↓ 74.0 74 4 / 3

Index Scan using pk_stg_item_score on stg_item_score x (cost=0.56..8.58 rows=1 width=74) (actual time=0.025..0.104 rows=74 loops=4)

  • Index Cond: ((administrationid = 593317) AND (studentidcode = asmt.studentidcode) AND (documentidcode = asmt.documentidcode) AND (testeventidcode = asmt.testeventidcode))
8. 31.277 53.938 ↑ 1.0 216 298

Hash Join (cost=1.30..9.77 rows=216 width=43) (actual time=0.002..0.181 rows=216 loops=298)

  • Hash Cond: (obj.subtestid = tst.subtestid)
9. 22.648 22.648 ↑ 1.0 216 298

Seq Scan on dim_objective obj (cost=0.00..7.70 rows=216 width=31) (actual time=0.001..0.076 rows=216 loops=298)

  • Filter: (administrationid = 593317)
10. 0.007 0.013 ↑ 1.0 12 1

Hash (cost=1.15..1.15 rows=12 width=12) (actual time=0.013..0.013 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.006 0.006 ↑ 1.0 12 1

Seq Scan on dim_subtest tst (cost=0.00..1.15 rows=12 width=12) (actual time=0.003..0.006 rows=12 loops=1)

  • Filter: (administrationid = 593317)
12. 0.894 0.894 ↑ 1.0 1 298

Index Scan using pk_dim_participant on dim_participant pat (cost=0.42..8.44 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=298)

  • Index Cond: (participantid = 13843)
  • Filter: (administrationid = 593317)
13. 0.596 0.596 ↑ 1.0 1 298

Index Only Scan using idx_dim_organizations_1 on dim_organizations org (cost=0.29..4.31 rows=1 width=12) (actual time=0.002..0.002 rows=1 loops=298)

  • Index Cond: ((administrationid = 593317) AND (orglevel = 2) AND (organizationid = pat.organizationid))
  • Heap Fetches: 0
Planning time : 3.955 ms
Execution time : 179.045 ms