explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u6BT

Settings
# exclusive inclusive rows x rows loops node
1. 1,042.273 2,170.680 ↑ 5,642.0 1 1

Seq Scan on api_host h (cost=0.00..4,881,756.22 rows=5,642 width=16) (actual time=1,469.583..2,170.680 rows=1 loops=1)

  • Filter: ((SubPlan 1) @> '{{2}}'::integer[])
  • Rows Removed by Filter: 1128406
2.          

SubPlan (for Seq Scan)

3. 1,128.407 1,128.407 ↓ 0.0 0 1,128,407

Index Only Scan using api_hosttag_hosts_host_id_hosttag_id_index on api_hosttag_hosts hth (cost=0.29..4.30 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1,128,407)

  • Index Cond: (host_id = h.system_uuid)
  • Heap Fetches: 0
Planning time : 0.358 ms
Execution time : 2,170.707 ms