explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9GxV

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 5,829.460 ↑ 1.0 100 1

Limit (cost=1.43..198.16 rows=100 width=16) (actual time=5,828.971..5,829.460 rows=100 loops=1)

2. 0.064 5,829.452 ↑ 84,088.1 100 1

Nested Loop (cost=1.43..16,542,707.03 rows=8,408,806 width=16) (actual time=5,828.970..5,829.452 rows=100 loops=1)

3. 0.000 5,829.288 ↑ 27,189.5 100 1

Nested Loop (cost=0.99..14,954,941.45 rows=2,718,945 width=24) (actual time=5,828.964..5,829.288 rows=100 loops=1)

4. 2,187.508 2,187.508 ↑ 3.8 3,980,421 1

Index Scan using idx_orders_status_confirmed_at on orders o (cost=0.56..6,202,122.82 rows=14,988,631 width=16) (actual time=0.015..2,187.508 rows=3,980,421 loops=1)

5. 3,980.421 3,980.421 ↓ 0.0 0 3,980,421

Index Scan using order_attributes_order_id on order_attributes oad (cost=0.43..0.56 rows=2 width=8) (actual time=0.001..0.001 rows=0 loops=3,980,421)

  • Index Cond: (order_id = o.id)
  • Filter: (name = 'is_double_check_required'::text)
  • Rows Removed by Filter: 0
6. 0.100 0.100 ↑ 2.0 1 100

Index Scan using order_attributes_order_id on order_attributes oat (cost=0.43..0.56 rows=2 width=8) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: (order_id = o.id)
  • Filter: (name = 'is_terminal'::text)
  • Rows Removed by Filter: 1
Planning time : 1.614 ms
Execution time : 5,829.584 ms