explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FKry

Settings
# exclusive inclusive rows x rows loops node
1. 10,280.407 303,784.479 ↑ 1.0 1 1

Aggregate (cost=5,595,324.630..5,595,324.640 rows=1 width=8) (actual time=303,784.478..303,784.479 rows=1 loops=1)

  • Buffers: shared hit=1259040 read=476247 dirtied=352870, temp read=70242 written=70242
2. 289,018.159 293,504.072 ↑ 1.3 18,717,646 1

Bitmap Heap Scan on foxtrot foxtrot (cost=1,262,554.310..5,536,319.800 rows=23,601,930 width=8) (actual time=4,494.809..293,504.072 rows=18,717,646 loops=1)

  • Buffers: shared hit=1259040 read=476247 dirtied=352870
3. 4,485.913 4,485.913 ↑ 1.3 18,717,646 1

Bitmap Index Scan on mike (cost=0.000..1,256,653.830 rows=23,601,930 width=0) (actual time=4,485.913..4,485.913 rows=18,717,646 loops=1)

  • Index Cond: ((foxtrot.xray = ANY ('oscar'::integer[])) AND (foxtrot.juliet = 'two'::romeo.tango))
  • Buffers: shared hit=120821 read=118181