explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sKiq

Settings
# exclusive inclusive rows x rows loops node
1. 13.377 15,359.799 ↑ 243.2 24 1

HashAggregate (cost=84,298.10..84,356.48 rows=5,838 width=16) (actual time=15,359.768..15,359.799 rows=24 loops=1)

  • Group Key: veiculo_id
2. 12,651.713 15,346.422 ↓ 1.6 68,770 1

Bitmap Heap Scan on veiculo_motorista (cost=909.92..84,084.08 rows=42,803 width=8) (actual time=2,697.714..15,346.422 rows=68,770 loops=1)

  • Recheck Cond: (veiculo_id = ANY ('{73660,73692,73667,73679,73654,73678,73649,73652,73661,73675,73677,73681,73685,73671,73672,73669,73683,73688,73690,73680,71905,73682,73665,73693}'::bigint[]))
  • Filter: (status_embarque = ANY ('{1,2,3}'::integer[]))
  • Rows Removed by Filter: 662
  • Heap Blocks: exact=17270
3. 2,694.709 2,694.709 ↓ 1.3 69,480 1

Bitmap Index Scan on veiculo_motorista_veiculo_id_idx (cost=0.00..899.22 rows=54,503 width=0) (actual time=2,694.709..2,694.709 rows=69,480 loops=1)

  • Index Cond: (veiculo_id = ANY ('{73660,73692,73667,73679,73654,73678,73649,73652,73661,73675,73677,73681,73685,73671,73672,73669,73683,73688,73690,73680,71905,73682,73665,73693}'::bigint[]))
Planning time : 0.650 ms
Execution time : 15,360.113 ms