explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5XQb

Settings
# exclusive inclusive rows x rows loops node
1. 197.882 4,018.832 ↓ 2.7 1,120,936 1

Hash Join (cost=592,628.17..667,194.09 rows=420,957 width=12) (actual time=2,434.257..4,018.832 rows=1,120,936 loops=1)

  • Buffers: shared hit=92651, temp read=15639 written=15639
2. 978.489 3,820.650 ↓ 2.7 1,120,936 1

Hash Join (cost=592,537.52..665,522.88 rows=420,957 width=8) (actual time=2,433.807..3,820.65 rows=1,120,936 loops=1)

  • Buffers: shared hit=92572, temp read=15639 written=15639
3. 417.391 417.391 ↓ 1.0 1,120,936 1

Seq Scan on t_e20so1_document_datastore_16 document (cost=0..70,059.52 rows=1,114,602 width=16) (actual time=0.019..417.391 rows=1,120,936 loops=1)

  • Filter: (document.c_datastoresid = 16)
  • Buffers: shared hit=56127
4. 363.821 2,424.770 ↓ 3.0 1,244,521 1

Hash (cost=587,275.55..587,275.55 rows=420,957 width=8) (actual time=2,424.77..2,424.77 rows=1,244,521 loops=1)

  • Buffers: shared hit=36445, temp written=2125
5. 1,386.009 2,060.949 ↓ 3.0 1,244,521 1

HashAggregate (cost=578,856.41..583,065.98 rows=420,957 width=8) (actual time=1,697.532..2,060.949 rows=1,244,521 loops=1)

  • Group Key: bool.c_documentid
  • Buffers: shared hit=36445
6. 674.940 674.940 ↓ 3.8 2,367,600 1

Index Scan using test_boolean_folder on t_e20so1_document_boolean_folders bool (cost=0.57..577,302.89 rows=621,409 width=8) (actual time=0.037..674.94 rows=2,367,600 loops=1)

  • Index Cond: ((bool.c_fieldid = ANY ('{2e65e79e-01b5-424a-adaf-34ec69ba8267,7151a8d5-1d04-4ec8-9539-c2899535a99e,ebb310d2-a94e-4703-a5f8-36e248dc7fd5,cdd85816-6662-4062-8719-423d52628d8b,eca5ae2e-3fed-469f-9c48-b660b548d078,cac2636d-9ea6-4a27-80ca-a21ccadb4100,7e331df7-9905-4f9a-b6db-aab54c66c98d,e133540e-bb65-42c0-b1cc-7085fdc4887e,7490011b-f17a-42ea-ab24-970cc5b40b19,2cedee8e-ac4d-4677-a1b9-d2dd27152d8d,a325669a-5ad1-40af-8a11-5c41b13b86e5,6da62c3a-718c-41d3-b250-b8c0eaf13cf9,7b222840-580e-4d4e-9f0c-713ddfa94754,828a9c38-40aa-4a26-8787-b0b9a20c7d3e,4c5fef8c-fc8b-40d3-a54d-c46be94040f9,8d47499b-6715-4d6b-b4d5-3942bce6a97d,11c9ce11-3f10-4aed-897f-6ded67e25caf,f62bcaf0-f733-44e9-a809-0c5ebcc225bb,dcd2cd4c-6021-41e8-a9ed-6839d813155e,e5e95562-025b-4bfa-858f-faeb268b971b,a7d941d7-f34b-403c-9909-dd64dc6ec9a3,581cf487-09aa-4e36-939b-8a5fc7a5b259,3b6b7335-d5a7-4c2a-9b90-ec7098c2d9a7,4dba2de6-e157-4fa3-9980-79e60ff49238,694621c1-a915-499c-bc87-2cd3bab08594,6a90b1ae-12c1-4bf4-80e7-9042353bffe0,46363d59-7ad8-4d8d-9e5e-ce46d160c2f1,9c82e7db-af20-43dc-a9be-0a8833d3c9fd,4f09e2f9-bf09-45e8-a192-8d3d51a6ba8e}'::uuid[])) AND (bool.c_value = true))
  • Filter: bool.c_value
  • Buffers: shared hit=36445
7. 0.081 0.300 ↑ 1.0 518 1

Hash (cost=84.18..84.18 rows=518 width=8) (actual time=0.299..0.3 rows=518 loops=1)

  • Buffers: shared hit=79
8. 0.219 0.219 ↑ 1.0 518 1

Seq Scan on t_e20so1_emailthread EmailThreading (cost=0..84.18 rows=518 width=8) (actual time=0.033..0.219 rows=518 loops=1)

  • Buffers: shared hit=79
Planning time : 0.562 ms
Execution time : 4,090.587 ms