explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SvIG

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

Group (cost=29,367.81..29,367.82 rows=1 width=643) (actual time=314.811..314.811 rows=0 loops=1)

  • Group Key: dl.name, dlitem.id
2. 0.010 314.811 ↓ 0.0 0 1

Sort (cost=29,367.81..29,367.82 rows=1 width=643) (actual time=314.811..314.811 rows=0 loops=1)

  • Sort Key: dlitem.id
  • Sort Method: quicksort Memory: 25kB
3. 0.000 314.801 ↓ 0.0 0 1

Nested Loop (cost=23.86..29,367.80 rows=1 width=643) (actual time=314.801..314.801 rows=0 loops=1)

  • Join Filter: (dl.id = dlgc.data_list_id)
4. 0.001 314.801 ↓ 0.0 0 1

Nested Loop Semi Join (cost=23.86..29,337.88 rows=1 width=651) (actual time=314.801..314.801 rows=0 loops=1)

  • Join Filter: ((((doc.content -> 'model'::text) -> (dl.name)::text) ->> 'acronym'::text) = ((dlitem.content -> 'properties'::text) ->> 'acronym'::text))
5. 0.015 2.852 ↓ 7.0 7 1

Nested Loop (cost=23.43..676.58 rows=1 width=651) (actual time=0.464..2.852 rows=7 loops=1)

6. 1.508 2.763 ↑ 1.4 37 1

Hash Join (cost=23.14..656.21 rows=51 width=651) (actual time=0.259..2.763 rows=37 loops=1)

  • Hash Cond: (dlitem.data_list_id = dl.id)
7. 1.053 1.053 ↑ 1.0 20,511 1

Seq Scan on data_list_item dlitem (cost=0.00..555.57 rows=20,557 width=631) (actual time=0.006..1.053 rows=20,511 loops=1)

8. 0.003 0.202 ↑ 3.0 1 1

Hash (cost=23.10..23.10 rows=3 width=20) (actual time=0.202..0.202 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.199 0.199 ↑ 3.0 1 1

Seq Scan on data_list dl (cost=0.00..23.10 rows=3 width=20) (actual time=0.008..0.199 rows=1 loops=1)

  • Filter: ((name)::text = 'trecho'::text)
  • Rows Removed by Filter: 1,243
10. 0.074 0.074 ↓ 0.0 0 37

Index Scan using "data_list_itemPK" on data_list_item dlitemparent (cost=0.29..0.39 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=37)

  • Index Cond: (id = dlitem.parent_id)
  • Filter: ((content -> 'properties'::text) = '{"name": "Seccionamento", "acronym": "SC"}'::jsonb)
  • Rows Removed by Filter: 1
11. 0.006 311.948 ↓ 0.0 0 7

Materialize (cost=0.43..28,658.99 rows=84 width=658) (actual time=44.564..44.564 rows=0 loops=7)

12. 0.092 311.942 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.43..28,658.57 rows=84 width=658) (actual time=311.942..311.942 rows=0 loops=1)

13. 29.416 29.416 ↓ 1.5 283 1

Seq Scan on document doc (cost=0.00..14,647.69 rows=193 width=666) (actual time=0.066..29.416 rows=283 loops=1)

  • Filter: (project_id = 105)
  • Rows Removed by Filter: 122,492
14. 282.434 282.434 ↓ 0.0 0 283

Index Scan using vcl_document_id_idx on vcl (cost=0.43..338.20 rows=6 width=8) (actual time=0.998..0.998 rows=0 loops=283)

  • Index Cond: (document_id = doc.id)
  • Filter: (((office_id IS NULL) OR (office_id = 119)) AND ((profile_id IS NULL) OR (profile_id = ANY ('{144,155,1492,1948,146,2012,149,147,153,150,1493,2286}'::bigint[]))))
  • Rows Removed by Filter: 81
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on data_list_config_item_group dlgc (cost=0.00..29.45 rows=38 width=8) (never executed)

  • Filter: (config_item_group_id = 104)
Planning time : 0.885 ms
Execution time : 314.914 ms