explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9sU

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 155.406 ↓ 6.0 6 1

Group (cost=1.01..130,386.57 rows=1 width=643) (actual time=0.604..155.406 rows=6 loops=1)

  • Group Key: dl.name, dlitem.id
2. 0.023 155.399 ↓ 6.0 6 1

Nested Loop (cost=1.01..130,386.56 rows=1 width=643) (actual time=0.601..155.399 rows=6 loops=1)

  • Join Filter: (dl.id = dlgc.data_list_id)
  • Rows Removed by Join Filter: 180
3. 9.799 154.674 ↓ 6.0 6 1

Nested Loop Semi Join (cost=1.01..130,356.64 rows=1 width=651) (actual time=0.594..154.674 rows=6 loops=1)

  • Join Filter: ((((doc.content -> 'model'::text) -> (dl.name)::text) ->> 'acronym'::text) = ((dlitem.content -> 'properties'::text) ->> 'acronym'::text))
  • Rows Removed by Join Filter: 20,599
4. 0.016 8.501 ↓ 7.0 7 1

Nested Loop (cost=0.57..1,934.97 rows=1 width=651) (actual time=0.377..8.501 rows=7 loops=1)

5. 4.851 8.411 ↑ 1.4 37 1

Nested Loop (cost=0.29..1,914.60 rows=51 width=651) (actual time=0.343..8.411 rows=37 loops=1)

  • Join Filter: (dlitem.data_list_id = dl.id)
  • Rows Removed by Join Filter: 20,474
6. 3.560 3.560 ↑ 1.0 20,511 1

Index Scan using "data_list_itemPK" on data_list_item dlitem (cost=0.29..966.43 rows=20,557 width=631) (actual time=0.006..3.560 rows=20,511 loops=1)

7. 0.000 0.000 ↑ 3.0 1 20,511

Materialize (cost=0.00..23.12 rows=3 width=20) (actual time=0.000..0.000 rows=1 loops=20,511)

8. 0.164 0.164 ↑ 3.0 1 1

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

  • Filter: ((name)::text = 'trecho'::text)
  • Rows Removed by Filter: 1,243
9. 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
10. 14.428 136.374 ↑ 3.0 2,944 7

Materialize (cost=0.43..127,446.24 rows=8,743 width=658) (actual time=0.003..19.482 rows=2,944 loops=7)

11. 12.176 121.946 ↓ 2.3 20,074 1

Nested Loop Semi Join (cost=0.43..126,667.52 rows=8,743 width=658) (actual time=0.018..121.946 rows=20,074 loops=1)

12. 29.474 29.474 ↓ 1.0 20,074 1

Seq Scan on document doc (cost=0.00..14,647.69 rows=20,012 width=666) (actual time=0.006..29.474 rows=20,074 loops=1)

  • Filter: (project_id = 104)
  • Rows Removed by Filter: 102,701
13. 80.296 80.296 ↑ 6.0 1 20,074

Index Scan using vcl_document_id_idx on vcl (cost=0.43..24.56 rows=6 width=8) (actual time=0.004..0.004 rows=1 loops=20,074)

  • 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: 3
14. 0.702 0.702 ↑ 1.2 31 6

Seq Scan on data_list_config_item_group dlgc (cost=0.00..29.45 rows=38 width=8) (actual time=0.003..0.117 rows=31 loops=6)

  • Filter: (config_item_group_id = 104)
  • Rows Removed by Filter: 1,213
Planning time : 0.840 ms
Execution time : 156.713 ms