explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bqD3

Settings
# exclusive inclusive rows x rows loops node
1. 671,796.873 672,364.697 ↑ 1.1 1,807,833 1

Bitmap Heap Scan on wikidata_20190805.item_statements (cost=36,602.65..5,792,232.58 rows=1,955,365 width=183) (actual time=1,009.199..672,364.697 rows=1,807,833 loops=1)

  • Output: id, mainsnak_datatype, datavalue_datatype, source_item_id, edge_property_id, target_datavalue, el_rank
  • Recheck Cond: (item_statements.edge_property_id = 570)
  • Heap Blocks: exact=1334364
  • Buffers: shared read=1339308
2. 567.824 567.824 ↑ 1.1 1,807,833 1

Bitmap Index Scan on item_statements_edge_property_id_idx (cost=0.00..36,113.81 rows=1,955,365 width=0) (actual time=567.824..567.824 rows=1,807,833 loops=1)

  • Index Cond: (item_statements.edge_property_id = 570)
  • Buffers: shared read=4944
Planning time : 0.106 ms
Execution time : 672,514.125 ms