explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QpBR

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 1.517 ↑ 8.0 1 1

Append (cost=0.00..409.07 rows=8 width=203) (actual time=0.063..1.517 rows=1 loops=1)

2. 0.030 0.030 ↓ 0.0 0 1

Seq Scan on business sb (cost=0.00..4.97 rows=1 width=7) (actual time=0.030..0.030 rows=0 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
  • Rows Removed by Filter: 158
3. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on broker_business sb_1 (cost=0.00..1.01 rows=1 width=516) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
  • Rows Removed by Filter: 1
4. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on business_history sb_2 (cost=0.00..2.66 rows=1 width=19) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
  • Rows Removed by Filter: 53
5. 1.155 1.155 ↑ 1.0 1 1

Seq Scan on carrier_business sb_3 (cost=0.00..291.02 rows=1 width=19) (actual time=0.018..1.155 rows=1 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
  • Rows Removed by Filter: 7841
6. 0.034 0.034 ↓ 0.0 0 1

Seq Scan on shipper_business sb_4 (cost=0.00..6.40 rows=1 width=8) (actual time=0.034..0.034 rows=0 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
  • Rows Removed by Filter: 192
7. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on broker_business_history sb_5 (cost=0.00..10.25 rows=1 width=516) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
8. 0.273 0.273 ↓ 0.0 0 1

Seq Scan on carrier_business_history sb_6 (cost=0.00..82.38 rows=1 width=23) (actual time=0.273..0.273 rows=0 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
  • Rows Removed by Filter: 2110
9. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on shipper_business_history sb_7 (cost=0.00..10.38 rows=1 width=516) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: (id = '1703858125129385245'::bigint)
Planning time : 1.298 ms
Execution time : 1.556 ms