explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ocTu : Test

Settings
# exclusive inclusive rows x rows loops node
1. 0.055 27,225.993 ↓ 4.0 4 1

Sort (cost=2,074.09..2,074.09 rows=1 width=58) (actual time=27,225.993..27,225.993 rows=4 loops=1)

  • Sort Key: node_field_revision.changed DESC NULLS LAST
  • Sort Method: quicksort Memory: 25kB
2. 0.012 27,225.938 ↓ 4.0 4 1

Nested Loop (cost=11.44..2,074.08 rows=1 width=58) (actual time=4,414.307..27,225.938 rows=4 loops=1)

3. 2.993 27,225.862 ↓ 4.0 4 1

Nested Loop (cost=11.03..2,071.29 rows=1 width=78) (actual time=4,414.277..27,225.862 rows=4 loops=1)

4. 4.308 26,910.299 ↓ 906.0 906 1

Nested Loop (cost=10.61..2,070.53 rows=1 width=78) (actual time=11.796..26,910.299 rows=906 loops=1)

5. 3.450 26,896.025 ↓ 906.0 906 1

Nested Loop (cost=10.32..2,070.19 rows=1 width=74) (actual time=11.741..26,896.025 rows=906 loops=1)

6. 1.597 43.265 ↓ 906.0 906 1

Nested Loop (cost=9.9..50.45 rows=1 width=74) (actual time=0.192..43.265 rows=906 loops=1)

7. 7.133 36.232 ↓ 906.0 906 1

Nested Loop (cost=9.61..42.14 rows=1 width=74) (actual time=0.149..36.232 rows=906 loops=1)

8. 2.622 13.697 ↓ 906.0 906 1

Nested Loop (cost=5.3..30.08 rows=1 width=58) (actual time=0.128..13.697 rows=906 loops=1)

9. 0.772 3.827 ↓ 906.0 906 1

Nested Loop (cost=5.02..21.77 rows=1 width=55) (actual time=0.074..3.827 rows=906 loops=1)

10. 0.003 0.061 ↑ 1.0 1 1

Nested Loop (cost=4.6..20.35 rows=1 width=32) (actual time=0.061..0.061 rows=1 loops=1)

11. 0.024 0.041 ↑ 1.0 1 1

Bitmap Heap Scan on group_content_field_data group_content_field_data_node_field_data (cost=4.31..12.04 rows=1 width=24) (actual time=0.041..0.041 rows=1 loops=1)

  • Filter: ((type)::text = 'business-group_node-product'::text)
  • Heap Blocks: exact=3
12. 0.017 0.017 ↓ 1.5 3 1

Bitmap Index Scan on "drupal_qOlhyEZiwJCdbJJ8KTw2YkJQcHgPIOSbBnx1VXE4vyI_idx" (cost=0..4.3 rows=2 width=0) (actual time=0.017..0.017 rows=3 loops=1)

  • Index Cond: (gid = '3094667'::bigint)
13. 0.017 0.017 ↑ 1.0 1 1

Index Scan using node_field_data____pkey on node_field_data node_field_data_node_field_revision (cost=0.29..8.31 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: ((nid = group_content_field_data_node_field_data.entity_id) AND ((langcode)::text = 'en'::text))
  • Filter: ((type)::text = 'product'::text)
14. 2.994 2.994 ↓ 151.0 906 1

Index Scan using node_field_revision__node__id__default_langcode__langcode__idx on node_field_revision node_field_revision (cost=0.42..1.36 rows=6 width=23) (actual time=0.012..2.994 rows=906 loops=1)

  • Index Cond: (nid = node_field_data_node_field_revision.nid)
  • Filter: (revision_translation_affected = '1'::smallint)
15. 7.248 7.248 ↑ 1.0 1 906

Index Only Scan using groups_field_data__group__id__default_langcode__langcode__idx on groups_field_data groups_field_data_group_content_field_data (cost=0.29..8.3 rows=1 width=11) (actual time=0.008..0.008 rows=1 loops=906)

  • Index Cond: (id = '3094667'::bigint)
  • Heap Fetches: 906
16. 9.060 15.402 ↑ 1.0 1 906

Bitmap Heap Scan on group_content_field_data group_content_field_data_groups_field_data (cost=4.31..12.04 rows=1 width=24) (actual time=0.011..0.017 rows=1 loops=906)

  • Filter: (((type)::text = 'business-group_membership'::text) AND (entity_id = '3080763'::bigint))
  • Heap Blocks: exact=2718
17. 6.342 6.342 ↓ 1.5 3 906

Bitmap Index Scan on "drupal_qOlhyEZiwJCdbJJ8KTw2YkJQcHgPIOSbBnx1VXE4vyI_idx" (cost=0..4.3 rows=2 width=0) (actual time=0.007..0.007 rows=3 loops=906)

  • Index Cond: (gid = '3094667'::bigint)
18. 5.436 5.436 ↑ 1.0 1 906

Index Only Scan using users_field_data__user__id__default_langcode__langcode__idx on users_field_data users_field_data_group_content_field_data (cost=0.29..8.3 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=906)

  • Index Cond: (uid = '3080763'::bigint)
  • Heap Fetches: 906
19. 26,849.310 26,849.310 ↑ 1.0 1 906

Index Scan using content_moderation_state_field_revision____pkey on content_moderation_state_field_revision content_moderation_state (cost=0.42..2,019.73 rows=1 width=7) (actual time=21.903..29.635 rows=1 loops=906)

  • Index Cond: ((langcode)::text = (node_field_revision.langcode)::text)
  • Filter: (((moderation_state)::text <> 'archived'::text) AND ((content_entity_type_id)::text = 'node'::text) AND ((workflow)::text = 'od_content_moderation'::text) AND (node_field_revision.vid = content_entity_revision_id))
20. 9.966 9.966 ↑ 1.0 1 906

Index Scan using node____pkey on node node (cost=0.29..0.34 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=906)

  • Index Cond: (nid = node_field_revision.nid)
  • Filter: ((type)::text = 'product'::text)
21. 312.570 312.570 ↑ 1.0 1 906

Index Scan using node_field_revision__node__id__default_langcode__langcode__idx on node_field_revision node_field_revision2 (cost=0.42..0.75 rows=1 width=19) (actual time=0.345..0.345 rows=1 loops=906)

  • Index Cond: ((node_field_revision.nid = nid) AND ((langcode)::text = (node_field_revision.langcode)::text))
  • Filter: ((revision_translation_affected = '1'::smallint) AND (vid > node_field_revision.vid))
22. 0.064 0.064 ↑ 1.0 1 4

Index Scan using node_access____pkey on node_access na (cost=0.42..2.78 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=4)

  • Index Cond: (nid = node_field_data_node_field_revision.nid)
  • Filter: ((grant_view >= 1) AND (fallback = 1) AND (((gid = '0'::bigint) AND ((realm)::text = 'all'::text)) OR ((gid = ANY ('{3094623,3094649,3094654,3094655,3094656,3094658,3094659,3094660,3094661,3094662,3094664,3094665,3094666,3094667,3094668,3094670,3094673,3094674,3094675,3094676,3094677,3094688,3094689,3094691,3094692,3094694,3094695,3094697,3094698,3094699,3094700,3094701,3094702,3094703,3094704,3094706,3094707,3094708,3094709,3094710,3094712,3094714,3094716,3094717,3094718,3094719,3094721,3094722,3094723,3094724,3094725,3094731,3094732,3094734,3094735,3094736,3094737,3094738,3094739,3094740,3094741,3094742,3094744,3094746,3094747,3094749,3094750,3094752,3094753,3094755,3178380,3230631,3232850,3232865,3635480,3735993,4226532,4375081,4486406,5068877,5110938,5111140,5162383,5328904,5328916,5595604,5869053,6245842,6375545,6389542,6898428,7054613}'::bigint[])) AND ((realm)::text = 'gnode:deal'::text)) OR ((gid = ANY ('{3094623,3094649,3094654,3094655,3094656,3094658,3094659,3094660,3094661,3094662,3094664,3094665,3094666,3094667,3094668,3094670,3094673,3094674,3094675,3094676,3094677,3094688,3094689,3094691,3094692,3094694,3094695,3094697,3094698,3094699,3094700,3094701,3094702,3094703,3094704,3094706,3094707,3094708,3094709,3094710,3094712,3094714,3094716,3094717,3094718,3094719,3094721,3094722,3094723,3094724,3094725,3094731,3094732,3094734,3094735,3094736,3094737,3094738,3094739,3094740,3094741,3094742,3094744,3094746,3094747,3094749,3094750,3094752,3094753,3094755,3178380,3230631,3232850,3232865,3635480,3735993,4226532,4375081,4486406,5068877,5110938,5111140,5162383,5328904,5328916,5595604,5869053,6245842,6375545,6389542,6898428,7054613}'::bigint[])) AND ((realm)::text = 'gnode_unpublished:deal'::text)) OR ((gid = ANY ('{3094623,3094649,3094654,3094655,3094656,3094658,3094659,3094660,3094661,3094662,3094664,3094665,3094666,3094667,3094668,3094670,3094673,3094674,3094675,3094676,3094677,3094688,3094689,3094691,3094692,3094694,3094695,3094697,3094698,3094699,3094700,3094701,3094702,3094703,3094704,3094706,3094707,3094708,3094709,3094710,3094712,3094714,3094716,3094717,3094718,3094719,3094721,3094722,3094723,3094724,3094725,3094731,3094732,3094734,3094735,3094736,3094737,3094738,3094739,3094740,3094741,3094742,3094744,3094746,3094747,3094749,3094750,3094752,3094753,3094755,3178380,3230631,3232850,3232865,3635480,3735993,4226532,4375081,4486406,5068877,5110938,5111140,5162383,5328904,5328916,5595604,5869053,6245842,6375545,6389542,6898428,7054613}'::bigint[])) AND ((realm)::text = 'gnode:product'::text)) OR ((gid = ANY ('{3094623,3094649,3094654,3094655,3094656,3094658,3094659,3094660,3094661,3094662,3094664,3094665,3094666,3094667,3094668,3094670,3094673,3094674,3094675,3094676,3094677,3094688,3094689,3094691,3094692,3094694,3094695,3094697,3094698,3094699,3094700,3094701,3094702,3094703,3094704,3094706,3094707,3094708,3094709,3094710,3094712,3094714,3094716,3094717,3094718,3094719,3094721,3094722,3094723,3094724,3094725,3094731,3094732,3094734,3094735,3094736,3094737,3094738,3094739,3094740,3094741,3094742,3094744,3094746,3094747,3094749,3094750,3094752,3094753,3094755,3178380,3230631,3232850,3232865,3635480,3735993,4226532,4375081,4486406,5068877,5110938,5111140,5162383,5328904,5328916,5595604,5869053,6245842,6375545,6389542,6898428,7054613}'::bigint[])) AND ((realm)::text = 'gnode_unpublished:product'::text))))
Planning time : 11.697 ms
Execution time : 27,226.312 ms