explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bA45

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 11.864 ↑ 1.0 10 1

Limit (cost=1.56..354.93 rows=10 width=249) (actual time=2.414..11.864 rows=10 loops=1)

2. 0.008 11.862 ↑ 1,071.6 10 1

Nested Loop (cost=1.56..378,671.88 rows=10,716 width=249) (actual time=2.413..11.862 rows=10 loops=1)

  • Join Filter: (this_.id = this_1_.id)
3. 0.009 11.784 ↑ 1,071.6 10 1

Nested Loop (cost=1.14..373,833.60 rows=10,716 width=257) (actual time=2.396..11.784 rows=10 loops=1)

  • Join Filter: (this_.id = this_2_.id)
4. 0.485 11.695 ↑ 1,071.6 10 1

Nested Loop (cost=0.72..368,500.15 rows=10,716 width=233) (actual time=2.379..11.695 rows=10 loops=1)

5. 9.222 9.222 ↑ 795.7 994 1

Index Scan using idx_graphics_name_id_asc on graphics this_3_ (cost=0.42..112,190.55 rows=790,930 width=128) (actual time=0.134..9.222 rows=994 loops=1)

  • Filter: ((scope = 0) AND (nature = 1))
  • Rows Removed by Filter: 369
6. 1.988 1.988 ↓ 0.0 0 994

Index Scan using building_block_pkey on building_block this_ (cost=0.29..0.31 rows=1 width=105) (actual time=0.002..0.002 rows=0 loops=994)

  • Index Cond: (id = this_3_.id)
  • Filter: (prototype_id IS NULL)
  • Rows Removed by Filter: 0
7. 0.080 0.080 ↑ 1.0 1 10

Index Scan using hierarchical_graphics_pkey on hierarchical_graphics this_2_ (cost=0.42..0.49 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=10)

  • Index Cond: (id = this_3_.id)
8. 0.070 0.070 ↑ 1.0 1 10

Index Scan using page_element_pkey on page_element this_1_ (cost=0.42..0.44 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=10)

  • Index Cond: (id = this_2_.id)
Planning time : 2.407 ms
Execution time : 11.954 ms