explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AcWYV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 215.356 ↓ 0.0 0 1

Sort (cost=110,681.69..110,681.71 rows=8 width=116) (actual time=215.356..215.356 rows=0 loops=1)

  • Sort Key: ma.theme_number, mv.depend, mf.id
  • Sort Method: quicksort Memory: 25kB
2. 8.912 217.646 ↓ 0.0 0 1

Gather (cost=1,000.41..110,681.57 rows=8 width=116) (actual time=215.346..217.646 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.000 208.734 ↓ 0.0 0 5 / 5

Nested Loop (cost=0.42..109,680.77 rows=2 width=116) (actual time=208.734..208.734 rows=0 loops=5)

4. 0.001 208.734 ↓ 0.0 0 5 / 5

Nested Loop (cost=0.28..109,680.46 rows=2 width=93) (actual time=208.734..208.734 rows=0 loops=5)

5. 208.733 208.733 ↓ 0.0 0 5 / 5

Parallel Seq Scan on mask_appeal ma (cost=0.00..109,676.02 rows=2 width=12) (actual time=208.733..208.733 rows=0 loops=5)

  • Filter: (appeal_id = 382154025)
  • Rows Removed by Filter: 2095724
6. 0.000 0.000 ↓ 0.0 0 / 5

Index Scan using mask_values_pkey on mask_values mv (cost=0.28..2.22 rows=1 width=89) (never executed)

  • Index Cond: (id = ma.mask_id)
7. 0.000 0.000 ↓ 0.0 0 / 5

Index Scan using mask_fields_pkey on mask_fields mf (cost=0.14..0.15 rows=1 width=23) (never executed)

  • Index Cond: (id = mv.field_id)
Planning time : 0.631 ms
Execution time : 217.737 ms