explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 31pc

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 188.837 ↑ 1.0 800 1

Limit (cost=2.55..4,320.94 rows=800 width=114) (actual time=168.004..188.837 rows=800 loops=1)

2. 9.945 188.784 ↑ 152.3 800 1

Nested Loop Left Join (cost=2.55..657,713.77 rows=121,844 width=114) (actual time=168.002..188.784 rows=800 loops=1)

  • Filter: (SubPlan 1)
  • Rows Removed by Filter: 8604
3. 0.919 18.971 ↑ 25.9 9,404 1

Nested Loop Left Join (cost=0.56..161,197.43 rows=243,689 width=95) (actual time=0.054..18.971 rows=9,404 loops=1)

4. 8.648 8.648 ↑ 25.9 9,404 1

Index Scan Backward using bo_instance_pkey on bo_instance i (cost=0.42..122,242.02 rows=243,689 width=86) (actual time=0.037..8.648 rows=9,404 loops=1)

  • Filter: (NOT is_deleted)
  • Rows Removed by Filter: 98
5. 9.404 9.404 ↑ 1.0 1 9,404

Index Scan using bo_class_pkey on bo_class boc (cost=0.14..0.16 rows=1 width=17) (actual time=0.001..0.001 rows=1 loops=9,404)

  • Index Cond: (id = i.bo_class_id)
6. 9.404 159.868 ↑ 1.0 1 9,404

Aggregate (cost=1.99..2.00 rows=1 width=32) (actual time=0.017..0.017 rows=1 loops=9,404)

7. 150.464 150.464 ↓ 0.0 0 9,404

Seq Scan on tag t (cost=0.00..1.99 rows=1 width=9) (actual time=0.016..0.016 rows=0 loops=9,404)

  • Filter: ((NOT is_deleted) AND (i.tags @> ARRAY[id]))
  • Rows Removed by Filter: 79
8.          

SubPlan (forNested Loop Left Join)

9. 0.000 0.000 ↓ 0.0 0 9,404

Function Scan on json_array_elements_text el (cost=0.00..1.00 rows=100 width=0) (actual time=0.000..0.000 rows=0 loops=9,404)

Planning time : 0.628 ms
Execution time : 188.982 ms